Seperating Text Out Of All Text Fields

V

Vato Loco

can I use the "find" function using no special text?

I need to seperate the names out of the following string:


first JIM mi T. last JOHNSO
 
N

Norman Harker

Hi Vato Loco!

Easiest way will be to use Data > Text to Columns using the space as
the delimiter. Then discard the bits you don't want.
 
Top