View Single Post
  #9   Report Post  
Gord Dibben
 
Posts: n/a
Default

Jo

These are also control codes.

See here for most common.

http://www.asciitable.com/


Gord

On Sat, 8 Jan 2005 20:43:04 -0800, "jo" wrote:

how about other than symbols;

like carriage hard returns, soft returns, indents, tabs, c

are these control codes or values.
thanks,


"Gord Dibben" wrote:

StartRuncharmap.exe

OR download Chip Pearson's Symbolizer Add-in

http://www.cpearson.com/excel/chars.htm


Gord Dibben Excel MVP

On Tue, 4 Jan 2005 15:43:02 -0800, "jo" wrote:

where can I find a list defining all the key codes / values
like ALT 0010 = carriage return?
I assume they will be the same for all MS office apps?
jo




"Gord Dibben" wrote:

Rob

When replacing with: hold the ALT key and type 0010 on the NumPad(gray keys on
the right).

You won't see anything typed in the box, but it is there.

Gord Dibben Excel MVP


On Mon, 3 Jan 2005 11:27:02 -0800, Rob wrote:

I have this same questions and This answer did not not work for me. It is
inserting"<alt0010". Not a hard return. Please help

"jo" wrote:

excel 2003
how to find text or symbol in each cell and replace with hard carriage return