dlewis61
asked on
Excel: First name first and Comma deletion
Hall, Bill
jones, Marcia
Smith, Scott
in excel, how do I make first name first and get rid of the commas?
D
jones, Marcia
Smith, Scott
in excel, how do I make first name first and get rid of the commas?
D
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Russell, for some reason your formula leaves the comma at the end of "Marsha Jones,".
It also changes "Diddlehopper, John" to "John Didd".
ASKER
I find that it leaves a zero...
I find that it leaves a zero...What does?
If there's a problem with my code then please attach your workbook.
ASKER
OMG Can't believe it!! The code worked!! Thanks
D
D
You're absolutely right I made a mistake there, here is the correction:-
=CONCATENATE(RIGHT(A1,LEN( A1) - FIND(",",A1) - 1)," ",LEFT(A1,FIND(",",A1)-1))
=CONCATENATE(RIGHT(A1,LEN(
You're welcome and I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
ASKER
Thank you!
In formula it's:-
=CONCATENATE(RIGHT(A1,LEN(