I have a cell that contains someones name and then a username. I need to separate this cell into name and username column.
Here is an example of what I have in every cell,
Alex Barracka AB87897
I need it in the format
[Name Column] Alex Barracka [UN Column] AB87897
Every Username is 7 characters long and always on the end of the first cell.
=TRIM(LEFT(A2,LEN(A2)-7))
and
=RIGHT(A2,7)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
You could do it 2 ways:
1) Use "Text to columns" under "Data" (Ribbon), or
2) Assuming your data starts in A2, then in B2 for name use:
=Left(A2,LEN(A2)-8) and in C2 for username use:
=Right(A2,7)
And copy the formulas down.
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks