Formula to separate data from one cell into two cells? 1

[ahogg]

Hi all!

I'm currently reformatting an excel spreadsheet containing contact information for my firm. The data must be formatted for importing into a database, and therefore correct field mapping is necessary.
My problem is this. I have one column containing Name and Surname information and would like to be able to separate "Name" and "Surname" in two columns.
Thank you in advance!

Anthony

 

[carrr]

Try Data > Text to Columns

 

[carrr]

This elaborates a little further:

http://www.mvps.org/word/FAQs/TblsFldsFms/SplitFirstNameLastName.htm

 

[ahogg]

Thanks a lot carr... Was a pretty daft question, I suppose

 

[KenWright]

>>Was a pretty daft question, I suppose

Almost no such thing. We've all asked them at some point, so I wouldn't worry on that score. As for the question itself, it's a very common question, and easy for people to answer only as long as they actually know the answer. Keep asking those questions - it's the only way to learn.

Regards
Ken...............

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------