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: 31232
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 7 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.