Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a download into Excel which contains names, however the full name is
in one cell eg Mr J Smith Mrs S Jones Mr A B Thompson I can extract the title, ie Mr and I can extract the Last name, ie Smith using formulas. Where Im hitting a wall is where there is more than one inititial. In effect, I am looking for a formula which will extract all text between the first space in the cell and the last space in the cell. Any help woud be greatly appreciated. |