Insert a symbol before the final word of a string

[kimi01]

I need to insert a symbol before the final word of a set of strings.

For example:
Old - The Big Brown Fox
New - The Big Brown +Fox

Old - The Very Big Brown Bear
New - The Very Big Brown +Bear

Could someone help with this please?

Thanks

[FDibbins]

If you want this in the same cell, you may need VBA for that (cant have a formula AND an entry in the same cell)

If this is going into an adjacent cell, then try this...
=SUBSTITUTE(F1," "," +",LEN(F1)-LEN(SUBSTITUTE(F1," ","")))

[kimi01]

That worked, thanks!