Search and replace with Carriage return

A

Andibevan

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
 
J

Jason Morin

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
 
A

Andibevan

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


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
 
Top