Computer Guy
asked on
Reformat a field in Excel
Hi, In Excel, how can I make BROOKS, GARTH to GARTH BROOKS magically?
if A2 has the lastname,firstname, you can put this in B2 and copy down:
[B2] = TRIM(RIGHT(A2,LEN(A2)-FIND (",",A2))) & " " &LEFT(A2,FIND(",",A2)-1)
This assumes that you may or may not have a space after the comma.
See attached.
Dave
example-r1.xls
[B2] = TRIM(RIGHT(A2,LEN(A2)-FIND
This assumes that you may or may not have a space after the comma.
See attached.
Dave
example-r1.xls
ASKER
Hi,
Thanks, I tried it and it works fine on the ones that are setup that way.
Now when I say have ALABAMA, this shows up in the field: #VALUE!
How can I do this automatically without having to change it manually?
Thanks!
Thanks, I tried it and it works fine on the ones that are setup that way.
Now when I say have ALABAMA, this shows up in the field: #VALUE!
How can I do this automatically without having to change it manually?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
.... Thinkpads_User