Seperating Text Out Of All Text Fields

  • Thread starter Thread starter Vato Loco
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

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

conditional formatting borders 9
Formula for stripping text 5
Formula for seperating data 1
Updating Split Text field 2
Text to columns 2
Concatenate and include trailing blanks 5
text to col with embedded mystery box 5
Macro Dialog Box 1

Back
Top