| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting Data with Line Break
I have a data within 1 excel cell as (used ALT+Enter to input data)
Hi Hello How Are You I am using concatenate funtion to merge this column with some other columns. After concatination everything appears in 1 line like "Hi Hello How Are You" I still want to bring output in multiple lines as above. Here is the contatination funtion.... =CONCATENATE("COMMENT ON COLUMN ",+A1,".",+B1," IS """, SUBSTITUTE(+C1,CHAR(10), " "),""";") Any suggestions ? Thanks Satwinder |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| line break does not appear in CSV | Excel Discussion (Misc queries) | |||
| Parse Before Line Break | Excel Worksheet Functions | |||
| Line break | Excel Discussion (Misc queries) | |||
| Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
| Line Break | Excel Discussion (Misc queries) | |||
Threaded Mode
