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

how to return data from a right hand side/and one cell down 4
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Delete first two characters in a cell... 6
limit characters returned a cell reference 8
find last populated cell in range of cells 6
Reverse a function to return the array? 4
Easiest way to extract characters in a cell LEFT or RIGHT of a sym 2
if function, multiple characters from right 4

Top