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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
replace new line character
Select your cells, then display the Replace dialog, With the cursor in the
Find What box, hold down the ALT key and type 0010 on the numeric keypad (not the numbers above the letters). Nothing will display, but the character will be there. Then enter something in the Replace With box. "ciruliz" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
replace new line character
If you used alt-enter for that new line character, you can
Select the range to fix edit|replace what: ctrl-j with: (spacebar) (or whatever you want) replace all ciruliz wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
replace new line character
good, big thanks for ideas.
Actually I figured out other way : simple VB macro: Public Sub ConvertCells() Dim Cell As Range For Each Cell In Application.Selection Cell = Replace(Cell, vbLf, " ") Next Cell End Sub which works as expected :) Best regards, Andis "ciruliz" wrote in message ... 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 |
Reply |
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 |