Carriage return in a cell

  • Thread starter Thread starter gcotterl
  • Start date Start date
G

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
 
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)
Click to expand...

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)
 
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)
Click to expand...

thank you!!!!!!!!!!!!
 
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)
Click to expand...
 
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).
Click to expand...

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)
 
Back
Top