select last name only from full name 1

[Jaffey]

I have a column containing "lastname, firstname"

I would like to have the last name only appear in another column.

Can someone please tell me the formula to use?

thanks!

 

[SkipVought]

Hi,

Check out Data > Text to columns...

Delimited on COMMA

Skip,
[sub]
When a wee mystic is on the loose..
It's a Small Medium at Large! [/sub]

 

[Jaffey]

I use that frequently for other purposes but it is not an option here. I was hoping to do it with a single formula. I know I can use LEN to select, say the first 10 characters, in the name but I'd like something that stops at the comma. I suspect there is a way to do it with LEN and SEARCH but I can't figure it out.

 

[AnotherHiggins]

=left(A1,find(",",A1)-1)

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[Jaffey]

That's great. Thanks John.