Formula for Name separated by Commas

Miles Allison

Hello,

Is there a formula that can give me all of the text to the left of a comma and all of the text to the right of a comma? I have a list of names and my LEFT FIND formulas aren't working correctly.

For example,

My list has names like this

Adam, Smith

Susan-Anne, Smith

Bob, Wilson

I need a First Name Column and a Last Name column

Thanks,

Jason Tarpinian

As long as there's just one comma in each name represented, you can separate them into first/last with these formulas:

First =LEFT(Name@row, FIND(",", Name@row) - 1)

Last =RIGHT(Name@row, LEN(Name@row) - FIND(",", Name@row) - 1)

Jason Tarpinian

As long as there's just one comma in each name represented, you can separate them into first/last with these formulas:

First =LEFT(Name@row, FIND(",", Name@row) - 1)

Last =RIGHT(Name@row, LEN(Name@row) - FIND(",", Name@row) - 1)

Miles Allison

That did work. Thank you so much!