Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I insert 'carriage/line returns' in text string?
Is there a function or code to enter 'carriage returns' in a text string? I
am using concatenate functions to extract and combine text and field names from a spreadsheet. The final (one cell) text of the row or 'record' is easier to share/confirm with those without access to the spreadsheet since I can then copy/paste the text from the one cell into an email. Currently, I don't know how to force the formatting or if it is possible. Currently the cell looks like: Name: Jim Smith Age: 29 City: New York. I'd like the text to be formatted with line returns like this: Name: Jim Smith Age: 29 City: New York |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I insert 'carriage/line returns' in text string?
="Name: Jim Smith"&CHAR(10)&
"Age: 29"&CHAR(10)& "City: New York" -- __________________________________ HTH Bob "DC-Frank" wrote in message ... Is there a function or code to enter 'carriage returns' in a text string? I am using concatenate functions to extract and combine text and field names from a spreadsheet. The final (one cell) text of the row or 'record' is easier to share/confirm with those without access to the spreadsheet since I can then copy/paste the text from the one cell into an email. Currently, I don't know how to force the formatting or if it is possible. Currently the cell looks like: Name: Jim Smith Age: 29 City: New York. I'd like the text to be formatted with line returns like this: Name: Jim Smith Age: 29 City: New York |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: How to insert carriage returns in a formula to manipulate t | Excel Worksheet Functions | |||
How do I insert a line break (carriage return) in text in a cell? | Excel Discussion (Misc queries) | |||
how to get rid of all Tabs, carriage returns, or new line characters | Excel Discussion (Misc queries) | |||
How can I enter carriage returns into text within a cell in excel | Excel Discussion (Misc queries) | |||
How do I get carriage returns to not be row delimiters in text fi. | Excel Discussion (Misc queries) |