Splitting Text in a Cell

[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.

 

[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 **

 

[Andy B]

Hi

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

 

[Brig]

Thank you very muuch.

That solved the problem.

Brig