Carriage Return in Excel

G

Guest

To insert a carriage return in Excel, I press ALT+ENTER. How do I do this
when using "Find and Replace"?

I want to replace a given character (",") with a carriage return across a
large range of cells.
 
A

Andy Brown

I want to replace a given character (",") with a carriage return across a
large range of cells.
Click to expand...

"Find What" = "," ; tab to the "Replace With" box, then type

0010

on the Number keypad while holding down ALT.

Click "Replace All".

Rgds,
Andy
 

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

Unicode text and carriage returns 4
Find and replace a space with carriage return in excel 2
Carriage return displays as a small box 8
Delete Carriage Returns 4
Carriage return during an if statement 4
vbYesNo, change carriage return 4
Replacing carriage returns with a comma 4
Create a flat file in Excel 4

Top