Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Putting text with Enter in one cell
Message
 
 
À
26/06/2002 10:18:46
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Divers
Thread ID:
00672107
Message ID:
00672614
Vues:
10
>>>>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.

Thanks again. I will use your idea in a future. Yesterday I just did everything manually (despite my and Dragan's motto) :)
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform