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

On Wed, 12 Jan 2011 17:06:51 -0800 (PST), 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



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)

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)

On Jan 12, 6:47*pm, "Rick Rothstein"
wrote:
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)

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

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



On 01/12/2011 20:47, Rick Rothstein wrote:
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)

--
Dave Peterson

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 meant ctrl-j, not ctrl-L

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)