How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Jess M. Your Own Question
Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 6960
Experience:  Computer Software Specialist for more than 10 years
Type Your Microsoft Office Question Here...
Jess M. is online now
A new question is answered every 9 seconds

I have a list of names that are space and comma delineated

Customer Question

I have a list of names that are space and comma delineated IE S Russell ; Adam Lewites ; ADAM MCDANIELS ; adam reeves ;
i want to get all in an exel file columns for first name last name and email address so that I can manipulate some of the data before importing into a crm software. I know how to do the text to columns part, but dont know how to transpose/paste special so that I get the result Im looking for
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Jess M. replied 1 year ago.

Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.

I am very sorry about your issues. Can you send me a sample of your Excel data so that I can directly check the best formula to fit your needs? You can attach the Excel file here when you reply using the paper clip icon.

Please let me know by replying to me here so that I can help you further.

Best regards,

Customer: replied 1 year ago.
Skip to content
Using ShermanandJames Mail with screen readers
Inbox (163)
Sent Mail
Drafts (3)
Notes (5)
twitter (276)
More labels
Will JamesSearch people...
Idle Christopher Burgett
Idle Jason sherman
Offline Mary Catherine Petermann
Alix James
***** *****
Chef David Reid
Christopher Burgett
Laura Bakken
Taylor Latham
1 of 498
Print all In new window
Fwd: sunday
x***** *****
8:43 PM (1 hour ago)to me-----Original Message-----
From: Hal Philipson
To: ***** ***** ; Adam Lewites ; ADAM MCDANIELS ; adam reeves ; akmgolf ; al kabus ; alex gaddy ; andrew fritts ; Andrew Steinberg ; Andy Feinour ; Ansley Golf Staff ; anthony Bratti ; Araya Mesfin ; Arik Kono ; bill Blincoe ; Bill Kilborn (*****@******.***) ; Bill Meagher ; bkitchen ; bob birdsong ; Bobby Kaufmann ; Brandon Farley ; brandon.howell ; bredan Gibbons ;***@******.*** (*****@******.***) ; Brent Herd ; Brian Gateley ; Brian Macaluso ; Brian Mann ; Brian Myers ; Brian Ramondt ;***@******.*** (*****@******.***) ; Bryan Blasingame (*****@******.***) ;***@******.*** (*****@******.***) ; Charlie Cooper ; Chip Hackett ; Chris Cummisky ; Chris Darley ; CHRIS FLOR ; ***** ***** ; Chris Mattie ;***@******.*** (*****@******.***) ; Chuck Tobias ; cjames ; cjyoung ; Colin Cavill ; Dale Seefeldt ; David Aiken ; david ruth ; david_edward_dwyer ; davidacasey13 ; ddendy ; doctor30306 ; Duncan Miller ; dwnfss ; eben hardie ; eddie Flynt ; edgarton ; EDWARD CADIGAN ; ***** ***** ; eric stotts ; Ernie Cain (*****@******.***) ; fox024 ; Gary Dresser (*****@******.***) ; Gene Newton ; George Pfeil ; GERAKITIS ; Graham Roberts ; Grant Campbell ; Greg Berkey ; Greg Maxey (*****@******.***) ; Greg Ryan ; gregberthelot ; Hal Philipson ; HANK FARMER ; Henley Hayes (*****@******.***) ; hunterwilliams ;***@******.*** (*****@******.***) ; IRA PEARL ; Jason Fritz ; Jason Godwin ; ***** ***** (*****@******.***) ; Jason Sherman ; jay imperatori ; jconant73 ; Jeff Schultz ; Jeffery Ervin ; jeremy Suspier ; ***** ***** ; Jim Kibler ; jim mcguire ; Jim Sanders ; jim schwartzcoff ; Jim Thanner ; jim.wheeler ; jim.womack ; Jimmy Morris ; ***** ***** ; ***** ***** ; Joey Harris ; John Dixon ; john.goger ; John.Nunneley ; Johnny Foster ; jon birdsong ; jon kaye <jon
Customer: replied 1 year ago.
excel attached list is above as the to in the email
Expert:  Jess M. replied 1 year ago.


Thank you for sample Excel file. Please give me a moment to check this file for you.


Customer: replied 1 year ago.
its not a sample its the excel file I want converted
Expert:  Jess M. replied 1 year ago.

Ok, so you got the data from an email message's TO or FROM field? Please give me a moment to check if this can be converted by Excel or if it needs to be extracted manually.

I will keep you posted.


Customer: replied 1 year ago.
I sent you the excel file also
Expert:  Jess M. replied 1 year ago.

Yeah, I am working on the excel file. I was able to isolate the data but few manual cleanup touches are required since the result is a single row only. Please give me a moment, I am working on this now.

Customer: replied 1 year ago.
Thats where i hot hung up. Couldnt grt first name in first column second in second and email in third
Expert:  Jess M. replied 1 year ago.

Ok I am working on it now.

Expert:  Jess M. replied 1 year ago.

Thank you for patiently waiting.

Here is the completed file:

I hope that helped.

Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated!

If you need further assistance, please do not rate me negatively with 1 or 2 faces. Instead, please reply to me so that I can help you further.

Thank you!

Best regards,