Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Putting text with Enter in one cell
Message
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Divers
Thread ID:
00672107
Message ID:
00673465
Vues:
24
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform