Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

select last name only from full name 1

Status
Not open for further replies.

Jaffey

Technical User
Jul 18, 2006
72
CA
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!
 




Hi,

Check out Data > Text to columns...

Delimited on COMMA

Skip,
[sub]
[glasses] When a wee mystic is on the loose..
It's a Small Medium at Large! [tongue][/sub]
 
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.
 
=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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top