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

 

[Ron Rosenfeld]

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

Use Find/Replace

Find What: , (,<space>)

Replace With: <alt+010> (hold down the <alt> key and type 010 on the numeric keypad, then release the <alt> key)

 

[Rick Rothstein]

Use Find/Replace

Find What: , (,<space>)

Replace With: <alt+010> (hold down the <alt> key and type 010 on the
numeric keypad, then release the <alt> key)

An alternative method to fill in the "Replace With" field is to simply
key-in Ctrl+L instead... the text cursor will look like it disappeared, but
actually a Line Feed was inserted and the cursor moved to the end of the
second line (which is located out of view below the bottom of the text box).

Rick Rothstein (MVP - Excel)

 

[gcotterl]

An alternative method to fill in the "Replace With" field is to simply
key-in Ctrl+L instead... the text cursor will look like it disappeared, but
actually a Line Feed was inserted and the cursor moved to the end of the
second line (which is located out of view below the bottom of the text box).

Rick Rothstein (MVP - Excel)

thank you!!!!!!!!!!!!

 

[Dave Peterson]

I bet you meant ctrl-j, not ctrl-L

An alternative method to fill in the "Replace With" field is to simply key-in
Ctrl+L instead... the text cursor will look like it disappeared, but actually a
Line Feed was inserted and the cursor moved to the end of the second line (which
is located out of view below the bottom of the text box).

Rick Rothstein (MVP - Excel)

 

[Rick Rothstein]

An alternative method to fill in the "Replace With" field is to simply

key-in
Ctrl+L instead... the text cursor will look like it disappeared, but
actually a
Line Feed was inserted and the cursor moved to the end of the second line
(which is located out of view below the bottom of the text box).

I bet you are right. Funny, I tested the keystroke out just before I posted
my message (that is when I noticed the text cursor "disappearing"), so how
did I screw up and type and L for a J? Thanks for catching that.

Rick Rothstein (MVP - Excel)