Returning the last word of a text string

[stuartw]

Hi All

I'm having a bit of bother with formula where I am trying to return just the last word of a string of text (on multiple rows).

The data looks like this:

New North East Pegasus
New North Technical
New South Sage
New North East Technical

etc etc.

Because there is more than on space I'm having trouble using the the FIND, LEFT, MID formulae, or more to the point I can't quite get the combination right.

Can anyone help?

Thanks in advance
Stuart

 

[barry houdini]

Hello Stuart,

If data starts at A2 try this formula in B2 copied down

=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",99)),99))