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
|