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 Chris L. Your Own Question

Chris L.
Chris L., Support Specialist
Category: Microsoft Office
Satisfied Customers: 4862
Experience:  Certified Expert with over 10 years experience.
51029781
Type Your Microsoft Office Question Here...
Chris L. is online now
A new question is answered every 9 seconds

I am trying to past multi-row text into one cell in Excel.

This answer was rated:

I am trying to past multi-row text into one cell in Excel. However when I do paste or even paste special with text option, I am getting the text in multiple rows. I have wrap text on. How do I make Excel to copy the text in the intended cell and NOT to split it over muliple rows?
Hello and thank you for using Just Answer.

Just so I am clear on what you are trying to do...

You want to copy ...
Row A | Row B
Into
Row C

Is this right ?
Customer: replied 5 years ago.

No.

 

I am copying text from a non-Excel source into one cell of an Excel sheet.

 

When I copy the text, it gets split on multiple rows. I want the text to stay in the very cell where I am pasting it.

Ok I see.

If you have not please highlight the cell. Then paste the text in the top formula bar.

If that does not help please let me know where the source text is from, is it from word and are you trying to keep the formatting?

Please let me know
Chris L. and 2 other Microsoft Office Specialists are ready to help you
Customer: replied 5 years ago.
The source is standard text element, which has formatting. I am not trying to keep the formatting. The formatting of the source can go. As a matter of fact. I am copying the source text into a plain text editor, which strips out formatting. I am them copying the text in Excel.
Customer: replied 5 years ago.
Problem solved. Thanks
You are welcome.