Search and replace with Carriage return

  • Thread starter Thread starter Andibevan
  • Start date Start date
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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replacing carriage returns with a comma 4
Unicode text and carriage returns 4
Formatting in formulas not allowed before commas 5
Carriage Return in Excel 3
Carriage return displays as a small box 8
Search and Replace Carriage Return 1
Getting rid of carriage return in cell 4
vbYesNo, change carriage return 4

Back
Top