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 Brandon M. Your Own Question

Brandon M.
Brandon M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 6977
Experience:  10+ Years Mac Support as contractor and currently an System Administrator for law firm
12024030
Type Your Microsoft Office Question Here...
Brandon M. is online now
A new question is answered every 9 seconds

I have an excel spreadsheet that has a list of names with the

This answer was rated:

I have an excel spreadsheet that has a list of names with the last name first followed by the first name. I need to have the first and second names split into two seperate columns.

BeBoo :

Hello and welcome to JustAnswer! My name is XXXXX XXXXX I would be glad to assist you with your issue today. Please note that I am in eastern time (UTC -5:00) and am generally online between the hours of 10 AM and 4 PM and some evenings between 7 PM and 11 PM.


Please also be patient with me as I may not respond immediately, especially outside my normal working hours. I do receive notification of all responses so I will respond when I am available next.


At the conclusion of today's session, I ask that you please rate based on the service you receive, not based on the circumstances. I do not receive compensation unless you rate at least 3/5. If you are considering rating 1 or 2, please let me know so that I can improve your satisfaction or allow me to opt out so another expert can better assist you.


Now, let's get to your question.

BeBoo :

Would you be willing to send me the excel spreadsheet?

Customer:

yes, just tell me the easiest way

BeBoo :

Sure. The easiest way would be to upload the file to WikiSend: http://www.wikisend.com/

BeBoo :

After you upload it, you will be given a File ID. Please give me that number.

Customer:

ok working on it now

Customer:

407592

Customer:

the names are XXXXX XXXXX D

BeBoo :

Ok, just a sec.

Customer:

if they have middle initials try to ignore that, just want first and last name

BeBoo :

Ok, the only issue seems to be is that there are company names in there as well

Customer:

company names are XXXXX XXXXX I can process those by hand

Customer:

most of them are individual names

BeBoo :

Ok, just a sec

Customer:

looks good, nothing we can do about the middle initial being in there?

BeBoo :

Do you not want it?

BeBoo :

Oh, you said to ignore it. Just a sec

Customer:

would prefer to have just first and last name, no initials

BeBoo :

That might not be too easy since some names don't even have middle initials. Give me a few more minutes.

Customer:

ok

BeBoo :

Got it. Just a sec

Customer:

perfect

Customer:

thank you

BeBoo :

No problem. Glad to help. Please be sure to rate based on the service you received today. Have a great evening.

Brandon M. and 3 other Microsoft Office Specialists are ready to help you