View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to substitute a comma with a newline char using Replace.

Or use ctrl-j


RagDyeR wrote:

Hold down <Alt,
And type
0010
Using the numbers on the Num keypad, *not* the numbers under the function
keys.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"edspyhill01" wrote in message
...
I am trying to replace all commas with a newline character. What do I put
in
the Replace field?


--

Dave Peterson