Search and replace with Carriage return
 

Hi there,

How do I search and replace a range with the following change - commas (,)
changed to carriage return (achieved by pressing alt+enter when typing in a
cell)

Regards

Andi

Select the range, press Ctrl+H, and in "find what" put a comma, and in
"replace with", hold down the ALT key and type 0010 on your numeric keypad.
Replace All.

HTH
Jason
Atlanta, GA

"Andibevan" wrote:

Hi there,

How do I search and replace a range with the following change - commas (,)
changed to carriage return (achieved by pressing alt+enter when typing in a
cell)

Regards

Andi

Thanks Jason - hadn't thought of doing it like that.


"Jason Morin" wrote in message
...
Select the range, press Ctrl+H, and in "find what" put a comma, and in
"replace with", hold down the ALT key and type 0010 on your numeric keypad.
Replace All.

HTH
Jason
Atlanta, GA

"Andibevan" wrote:

Hi there,

How do I search and replace a range with the following change - commas (,)
changed to carriage return (achieved by pressing alt+enter when typing in
a
cell)

Regards

Andi