View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ciruliz ciruliz is offline
external usenet poster
 
Posts: 3
Default 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