Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Putting text with Enter in one cell
Message
General information
Forum:
Microsoft Office
Category:
Excel
Miscellaneous
Thread ID:
00672107
Message ID:
00673465
Views:
25
This message has been marked as a message which has helped to the initial question of the thread.
>>>Hi everybody,
>>>
>>>We received an e-mail from the user with 35 items suggestions. I'm trying to put these items in the Excel spreadsheet. I'm doing it manually by copying each item and placing it into Excel. However, if text contains Enter (separate paragraphs), two or more cells got populated. Is it possible to make it insert this text in just one cell?
>>>
>>>Sorry for such novice question.
>>
>>Type Alt+Enter when you want to break to another line in the same cell. HTH
>
>Thanks again.

If you had hit F2 to say you wanted to edit the contents of the cell and then pasted the text with CR/LFs it would have put it all in the one cell.
___________________________
Kenneth Wonderley
http://www.wonderley.com


...the fruit of the Spirit is love, joy, peace, patience, kindness, goodness, faithfulness, gentleness and self-control.
Galatians 5:22 & 23
Previous
Reply
Map
View

Click here to load this message in the networking platform