Reverse last name first name in Excel without comma

Hope there is a way.....
I have entered my contacts into Outlook 2010 and exported them as a Windows CSV file to my desktop, I entered the contacts in all relevant fields as First Name and Last Name; John Smith but the exported CSV file has these as Last Name-Comma-First Name. The only way I can do this at present is to insert two additional columns B & C along side the A column showing the name as Smith, John.
Using the formula I found on this thread (Thanks Guy's!) of =TRIM(MID(A2&" "&A2,FIND(",",A2)+1,LEN(A2))) in column B I can convert back to John Smith, I then have to Copy Column B and Paste the results as Value into Column C.
I can then delete columns A & B and save. Then I can import into Google Contacts and sync with my Mobile (Cell) phone.

This seems a very long winded way to transferring data. I do not know if the problem lies with the way Outlook exports the data format or the way the CSV file imports the data format. It leaves Outlook as John Smith but gets swopped around on the way over!

Any idea where to start looking for a way to get John Smith into the CSV file correctly?

I would attach a couple of screenshots but it seems the forum does not like me so I am not allowed this function:

You may post new threads
You may post replies
You may not post attachments
You may edit your posts

Look guys, I am a nice pensioner with a dodgy back, polite, well spoken and a carer as well, what's not to like? :biggrin:

How do you reverse first name and last name in Excel with a comma?

One of the easiest and fastest ways to switch the first and the last name with a comma in between is by using the Flash Fill feature in Excel. Flash Fill is an amazing tool that works by identifying patterns in your data set (where you need to enter one or two expected result entries for it to identify the pattern).