Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to have carriage return in a cell
Message
From
15/03/2013 17:53:11
Rick Hodgin
Alabama, United States
 
 
To
15/03/2013 16:05:01
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
General information
Forum:
Microsoft Office
Category:
Excel
Title:
Re: How to have carriage return in a cell
Environment versions
Microsoft Office:
Office 2010
Miscellaneous
Thread ID:
01568522
Message ID:
01568533
Views:
24
>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)).
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform