Excel 2010: Replace space in full name with a new cell

[Larsen]

I have a Excel 2010 sheet with one row with names, full name (first name and last name), one cell each name, and I want to split first name and last name in two cells.

Is there any possibility to replace the space between first name and last name with a new cell or something?

Any help would be appreciated.

[thevink]

1)Highlight the whole column

2)Go to the ribbon: Data->Text to Columns

3)Make sure delimeted is selected and press next

4)Pick 'Space' as the delimeter and press next

5)Push finish, and your done

[MarkusDarkus]

Simples.

[Larsen]

  On 17/02/2011 at 14:21, thevink said:

1)Highlight the whole column

2)Go to the ribbon: Data->Text to Columns

3)Make sure delimeted is selected and press next

4)Pick 'Space' as the delimeter and press next

5)Push finish, and your done

Thank you. This helped alot.!