This may be a very "newbie" question but here goes.
I have a column with "lastname, firstname" within the same column. Is there a way to switch the text within the column to "firstname lastname"
Thanks in advance for any help.
~Tracy
This may be a very "newbie" question but here goes.
I have a column with "lastname, firstname" within the same column. Is there a way to switch the text within the column to "firstname lastname"
Thanks in advance for any help.
~Tracy
Try this in B1:
=MID(A1,FIND(",",A1)+1,256)&" "&LEFT(A1,FIND(",",A1)-1)
If A1="Barak, Obama", B1 will be "Obama Barak"
Quang PT
Assuming text in A1:
=TRIM(MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1)))
in another column. You can then copy that down the column, and then copy and paste special-values over the top to remove the formula.
Good luck.
Thank you, that did the trick!
Now, is there a way to get the result copied into a newly created column without the formula? Text only?
Thank you!!
Highlight all the data, copy, and paste as values to the new column (paste...or paste special.../paste values)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks