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 Richard Your Own Question

Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 33150
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I dont have time! I need an excel expert to take my spreadshee

Resolved Question:

I don't have time! I need an excel expert to take my spreadsheet. I have a list of movie theaters. Name, address, Citystzip all stacked in one column and separated by 2 rows all the way down the spreadsheet. Need converted to separate columns . The phone number is XXXXX there hanging out on a separate column.
Need you to take the excell and fix it now! Can you do it?
Submitted: 3 years ago.
Category: Microsoft Office
Expert:  Richard replied 3 years ago.
Thank you for your question, my name is Richard.

I will do it for you, just give me the sheet by doing the below please

- Click the following link: http://www.wikisend.com
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"

Thank you
Customer: replied 3 years ago.

Hi Richard. at wikisend...keep getting an error has occured while uploading The file is only 43K....please advise

Expert:  Richard replied 3 years ago.
ok, use this site instead and give me the download link please

http://ge.tt

Thank you
Customer: replied 3 years ago.

Heres the link http://ge.tt/36hmF8s/v/0

Also, pleae try to preserve Column J and L info ...i have some notes in column j and L for a few of the listings. If possible.

Expert:  Richard replied 3 years ago.
To make sure I understand

Colonie Center
131 Colonie Ctr
Albany, NYNNN-NN-NNNN

Should be in just on cell

Then two blank rows and the next one in one blank cell correct?

Customer: replied 3 years ago.

Hi Richard.

Yes....I believe that's right...however I looked at the sheet...which you now have...and it looks like there might be 2 or 3 or more blank rows between the info...its not consistent.

So we now have Colonie Center

131 Colonie Ctr.

Albany, NYNNN-NN-NNNN/p>

Please turn into:5 columns if you can

Colonie Center 131 Colonie Ctr Albany, NY NNN-NN-NNNN Tel #

Expert:  Richard replied 3 years ago.
ok, the data was very inconsistent Stephen, so I could only get it as much done as you see in this file

http://ge.tt/2O8wL8s/v/0?c

This is due to there being no structure with the data, so any process is going to have some failure.

Richard and 5 other Microsoft Office Specialists are ready to help you
Customer: replied 3 years ago.

Hi Richard. Yes, I see the zips need to be cleaned up, i can do that.

For the most part...you did it! I've got separate columns with address, City State zip and phone.

Thanks so much for getting me this so quickly.

Related Microsoft Office Questions