Carriage return in a cell
 

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

Carriage return in a cell
 

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)

On 01/12/2011 19:08, gcotterl wrote:
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