Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to have carriage return in a cell
Message
De
15/03/2013 17:53:11
Rick Hodgin
Alabama, États-Unis
 
 
À
15/03/2013 16:05:01
Michel Fournier
Level Extreme Inc.
Petit-Rocher, Nouveau-Brunswick, Canada
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Titre:
Re: How to have carriage return in a cell
Versions des environnements
Microsoft Office:
Office 2010
Divers
Thread ID:
01568522
Message ID:
01568533
Vues:
23
>Is there a way to have carriage returns in a cell? I am exporting data into Excel and some of that are memo fields. So, they contain lines and I would like the data to appear as is in the cell.


Use:
STRTRAN(data, CHR(10), SPACE(0)).
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform