replacing character with carriage return

M

Milo

In Word, I can replace all occurences of a semicolon with
a carriage return by putting ";" in the FIND field
and "^p" in the REPLACE-WITH field.

I'm looking for an equivalent in Excel. I know I can
cause a carriage return within a cell by typing Alt-Enter,
but if I wanted to replace all occurences of a character
with that, is there a symbol like ^p that I can use?
 
A

Andy Brown

Click in the Find What box and type 0010 on the number keypad *while holding
down ALT*. Nothing'll appear to happen, but don't worry about it.

Proceed as normal (Replace With, etc.).

Rgds,
Andy
 
G

Guest

Are you sure you don't have that backward?
If I'm replacing a semicolon with a carriage return,
wouldn't the funny code you gave me go in the Replace With
field?

Sure appreciate the info. Is there a chart somewhere with
the 0010 in it so that I can see what other things I might
use (like maybe 'tab')?
 

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

Splitting text divided by carriage returns 2
Alt+Enter character 3
Split data in field on character return 0
Replacing carriage returns with spaces in MS Word 5
Carriage returns in the formula bar? 4
^p means carriage return 6
What is that character, carriage return? 1
Replacing commas with carriage return 4

Top