Splitting Data and removing '

[moe10134]

I did an export from Outlook for Contacts. All Names came in Last NameFirstName. No spaces and they all have a ( ' ) in front of them. I need to switch them to display first name, last name. Preferably in two separate cells. A1: Bass, Jr. B1: Dave. Names are all different lengths. I can get rid of the ( ' ) with a replace or =TRIM() feature.

Example: 'Bass,Jr.Dave

Second Issue:
Emails came across as: dbassjr@charter.netSMTPdbassjr@charter.net

I'm debating on a Text to Columns splitting the .netSMTP to just have the result of : dbassjr@charter.net. I'm not very good at the =LEN() formulas to remove it that way. Any suggestions would be much appreciated.

Kind Regards,
-MOE10134

 

[fredlo2008]

Hi Moe,

I made you a spread sheet so you can use it as a tool to get your job done. I don't know how's you VBA level so I made it super simple to follow. Just copy the data you want into the spreadsheet and press the button.

I am using a function I got from this website http://www.excelbanter.com/showthread.php?t=225148 all merit for this creation goes to Jacob.

I am sure how to attach documents here so here is the link https://dl.dropbox.com/u/30987064/OutLookFixer.xlsm

Thanks a lot