How to substitute a comma with a newline char using Replace.
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.
|