View Single Post
  #10   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.

Whew!

Glad you found the problem and solution. (It restores my faith in excel!)

edspyhill01 wrote:

"edspyhill01" wrote:

It works. Must have been my sequence of selecting the cells and/or text.
Ctrl-J works the best, giving me one new line per comma. The Alt-0010 gives
me multiple new lines per comma but that is probably my error.

Thank you to all for the speedy help. This will save me hours of drudgery
formating test results for about 100,000 email aliases for pre and post
change comparisons from two SMTP servers.

Ed S.


Figured out the multiple new lines. DOH! The last text typed into the
Replace field stays pre-loaded when recalled, but, not seeing the new line on
a retry, I would add another one.

Both solutions work perfect.

Thanks again,

Ed S.


--

Dave Peterson