Carriage return in a cell

[gcotterl]

How can I replace each comma followed by a space with a carriage-
return?

For example, a cell contains:

COL-ACTN-TYPE, COL-ACTN-NBR, ET-AL-IND


I want:

COL-ACTN-TYPE
COL-ACTN-NBR
ET-AL-IND

 

[Dave Peterson]

Select the range to fix

Edit|Replace (or ctrl-h)
What: , (single comma, but I'd use comma followed by a space character)
with: ctrl-j (hit and hold the control key and hit the j key)
click replace all

It may not look like ctrl-j does anything in the "replace with" box, but if you
look closely, you may notice something.

Even if you don't notice anything, try it.

ctrl-j is the same as alt-enter or =char(10)