Need some assistance, new user trying to take a cell with lastname, firstname and transposing into another cell for a mail merge.
Need some assistance, new user trying to take a cell with lastname, firstname and transposing into another cell for a mail merge.
if you are looking to end up with Firstname Lastname then you could use:
=RIGHT(A1,LEN(A1)-FIND(",",A1)-1) & " " & LEFT(A1,FIND(",",A1)-1)
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
There's also the text to columns approach: highlight the list and select text to columns, then use a comma as a separator. To combine them, use =IF(C1="",B1&" "&A1,C1&" "&A1&", "&B1). This takes care of cases like Williams, Jr., Rick.
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks