Splitting Text in a Cell

B

Brig

Using Excel XP, I have a cell that has full names of people (First & Last
Names).

Can I split these two text somehow recognizing the space in between them?

Thank you.
 
P

Paul B

Brig, have a look at data, text to columns, post back if you need any help
with it

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
A

Andy B

Hi

One option is to use Data / Text to columns and tell the wizard it's
delimited with a space.
 
Top