I am trying to pull info from two different systems. The customer name in the first is first then last (Ann Laber
) the second is formatted last, first (Laber, Ann). Is there a simple way to make one format the same as the other. Does not matter which format.
thanks, Marilyn
Hi, welcome to the forum
Are they always just 2 names, no middle initial?
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
If there are just 2 names, try this (doesnt matter which way round you do it)...
aa, bb bb, aa bb, cc cc, bb cc, dd dd, cc
B1=MID(A1,FIND(",",A1,1)+2,99)&", "&LEFT(A1,FIND(",",A1,1)-1)
copied down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks