| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return cell characters after space
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return value based on number of characters in cell / field | Excel Worksheet Functions | |||
| Trim Characters Other Than An Empty Space At The End Of A Cell | Excel Worksheet Functions | |||
| Count Characters with space in a cell | Excel Discussion (Misc queries) | |||
| cHARACTERS BEFORE THE SPACE | Excel Worksheet Functions | |||
| If it's not a space, return the cell contents. | Excel Worksheet Functions | |||
Threaded Mode
