Splitting Forename & Surname in one cell

[Richard]

Is it possible to split a cell, for example in column A I
have 4000 full names, i would like to split it into two
columns: Forename & Surname
If possible...how??

Many Thanks in advance, Richard

 

[JE McGimpsey]

Data/Text to Columns.

For more sophisticated ways (i.e., to deal with initials, middle names,
etc.), check out

http://cpearson.com/excel/firstlast.htm

 

[Richard]

Thants superb, many thanks again, Richard

-----Original Message-----
Data/Text to Columns.

For more sophisticated ways (i.e., to deal with initials, middle names,
etc.), check out

http://cpearson.com/excel/firstlast.htm




.