| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
replace new line character
Hi,
I must replace all new line characters in cell contents by something (perhaps - space) before converting to CSV, because otherwise CSV becomes unreadable for other software. I know, in Ms Word it is possible to replace ^p (which stands for new line) with something It does`nt work in Excel. Any other options how to do that ? Thanks! Andis |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I stop a line in the middle of a chart? | Charts and Charting in Excel | |||
| Excel chart draws line outside Y axis | Charts and Charting in Excel | |||
| How do I use a formula to create a new line of text in a cell? | Excel Worksheet Functions | |||
| I need to replace a non printable character, A small white square | Excel Discussion (Misc queries) | |||
| Label an average line in a dynamic chart | Charts and Charting in Excel | |||
Threaded Mode
