Splitting a cell containing a name into two cells

[fuzzyjon]

Hello

I have a cell in my spreadsheet that contains a persons name.

I'd like to split the cell, or rather copy the firstname and surname, into two different cells. Obviously, the split point would be the space inbetween the two names but I can't work out how to do this!

I thought about using the e.g. =(LEFT A1,5) method, but the firstnames are all different lengths, so this would be no good.

Any help you could give me would be much appreciated!

Cheers,

Jon

 

[xenou]

Hi, this seems to be most commonly posted solution to this kind of problem:

1) Select the names
2) On main menu choose Data>TextToColumns
2) Tick the box for delimited | Next | tick the box for Space | Next | Finish

That seems to do it.

EDIT: Be sure to have an empty column available to the right...or several in case there are some cells with more than one space. Check the results in case anything is split into more than two columns.

 

[MickG]

Hi, Here's one way.

=+LEFT(A1,(FIND(" ",A1)))
=+RIGHT(A1,LEN(A1)-FIND(" ",A1))

Regards Mick

 

[BAlGaInTl]

Assuming that you just have Firstname Lastname

Here is a formula for the firstname:

=LEFT(A1,FIND(" ",A1)-1)

And the Lastname

=MID(A1,FIND(" ",A1)+1,255)

 

[fuzzyjon]

Thanks everyone!!!!

Cheers,

Jon