formula help

R

Raich

I have a list of names in one column and need a formula to split the info in
to to two columns ie First Name and then Surname. can anyone help?
 
P

Pete_UK

If you have a single space separating the first name from the surname,
you can highlight the column then use Data | Text-to-columns and
specify delimited with space as the delimiter.

Hope this helps.

Pete
 
Top