replace ^p

D

Dave Peterson

You mean alt-enters (to force new lines within cells)

Select the range to fix
edit|replace
what: ctrl-j
with: (space character???)
replace all

It may not look like the ctrl-j did anything, but give it a try.
 
S

shank

That worked. Where do I find a list of keyboard combinations that represent
special characters in Excel?

thanks
 
D

Dave Peterson

I don't know of a list.

But you could open CharMap
Windows start button|Run|charmap|and hit enter
to see the codes for each character.

You could have used alt-0010 (on the numeric keypad) instead of ctrl-j, but
ctrl-j is easier to describe and easier to do.
 
Top