Return cell characters after space

A

Andy

I have a cell with 'Mr J. Smith' and want to return in another cell 'Smith'.
As there are many other examples, I need a function that will seek out the
last ' ' in the cell content and then return all characters to the right
hand-side of this ' '.

e.g. 'Mr K Peters' would return 'Peters'

Please let me know if I can clarify!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy is criteria met 3
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
how to return data from a right hand side/and one cell down 4
Searching based on text 7
return partial string 5
Reverse a function to return the array? 4
find last populated cell in range of cells 6
If part of a cell = "NVA" then insert "Norfolk" in return cell 4

Top