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 John D Your Own Question

John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

i have the following in one cell of excel: "BOULEVARD SOUVENIRS

Customer Question

i have the following in one cell of excel:
It is on 2 lines. business name and phone number on 1 line
address on 2nd line. All in same cell.
I want to convert it to 1 cell per line. end results, 2 cells.

I have 125 lines like this. can i do them all at the same time and how do i do it?
Submitted: 3 years ago.
Category: Microsoft Office
Expert:  John D replied 3 years ago.

Here you go

The formulas are in the yellow cells

Attachment: 2013-01-04_225721_book1.xls

Hope this helps. Thank you for rating/bonus the answer if you found it helpful
Expert:  John D replied 3 years ago.

The site moderator has just forwarded a file from you. I'm not sure why. Hasn't the solution in the sample file that I sent you worked?