Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Putting text with Enter in one cell
Message
From
26/06/2002 10:18:46
 
General information
Forum:
Microsoft Office
Category:
Excel
Miscellaneous
Thread ID:
00672107
Message ID:
00672453
Views:
11
>>>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
>
>Great, thanks a lot. Is where a way to insert text with embedded Enter in the column?
>
>Though I already manually removed all Enters and put all the items in the Excel spreadsheet.

Not that I am aware of. The Alt+Enter inserts a line feed, so you could probably build a little program to replace all CR or CR+LF with just a LF for the column, and insert that in the cells.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform