Adding Symbols to Autocorrect

[alistew]

Hi

Is it possible to insert symbols into Autocorrect in Excel???

There is an option for this in word but I cant find it in Excel.

Is it possible??

thanks

 

[Dave Peterson]

If you can get the symbol into the clipboard (through charmap.exe???), then you
can use ctrl-v to paste into the "with" box on that dialog.

But since the autocorrect list is shared between the MS Office suite of
programs, maybe it would be easier to do this work in MSWord.

 

[alistew]

hi

thanks for the response.

i tried adding the symbol into autocorrect in word and it was fine but it
doesnt appear in the Excel autocorrect list. Is it supposed too?

 

[Dave Peterson]

I think so.

Can you share what you tried--the string to be corrected and the symbol, too.

And is this a plain text replacement or a formatted text replacement?

And what version of Office are you using?

 

[alistew]

Hi

I am using Office 2003.

I just wanted to replace the word Degree with the degree symbol.

thanks again.

alison

 

[alistew]

hi

i have found a way of doing this. i used the alt+0176 to insert it into my
autocorrect.

thanks for you help anyway.

also do you know where i can get a list of these codes?

 

[Dave Peterson]

Maybe you can try this in excel:

Tools|autocorrect options|autocorrect tab

Type: degree
in the replace box

Hold the altkey while typing 0176 on the number pad
in the with box.

Hi

I am using Office 2003.

I just wanted to replace the word Degree with the degree symbol.

thanks again.

alison

 

[Dave Peterson]

Start|Run|CharMap
and hit ok.

hi

i have found a way of doing this. i used the alt+0176 to insert it into my
autocorrect.

thanks for you help anyway.

also do you know where i can get a list of these codes?

 

[Dave Peterson]

ps. If you're using office 2002+, you can use:
Insert|symbol

Chip Pearson has an addin that may help (if you're using xl2k or lower).
http://www.cpearson.com/excel/download.htm
(look for Symbolizer and make sure you get the correct version)

hi

i have found a way of doing this. i used the alt+0176 to insert it into my
autocorrect.

thanks for you help anyway.

also do you know where i can get a list of these codes?

 

[alistew]

Hi

Thanks again. I actually meant the field code numbers. I found the 0176
number for the degree symbol just wondered if there was a place I could find
numbers for other symbols.

thanks
alison

 

[James Silverton]

alistew wrote on Sun, 18 Feb 2007 12:04:00 -0800:

a> Thanks again. I actually meant the field code numbers. I
a> found the 0176 number for the degree symbol just wondered if
a> there was a place I could find numbers for other symbols.

I you use Insert Symbol in Word, the listing of ASCII decimal
will give you a lot. If the font has Unicode hex available
(Arial certainly does) you will get a lot more. In Word, these
can be put into text by using the code(4-digits)ALT-x. Since
Excel (at least in the 2002 version that I have) does not allow
this route, the best tactic would be to insert them into
Autocorrect using Word since Autocorrect will work in Excel.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

 

[Ragdyer]

You could very easily "roll your own" character chart.

Then, you could format each column to a different font, and compare each one
to see where a simple keystroke of, say uppercase "P" would produce a check
mark in WingDings2, or an uppercase "J" would give you a smiley face in
WingDings.

You can also use it to see which char numbers produce which symbols.

On a new sheet, hide the first 31 rows.
In A32, type the name of your default font, usually Arial.

In A33, enter this formula:
=CHAR(ROW())
And copy it across maybe 10 columns, to J33.

Now, with A33 to J33 selected, drag down to copy to row 255.

Of course, all the cells (rows) presently display the same characters.

Now, select a column at a time, and assign a different font to each, putting
emphasis on the symbol fonts (WingDings & 2 & 3 - WebDings - Symbol), and
label each column in row 32 as you go.

With the actual row number as the Char number, this gives you a good map of
each different fonts display, and you can compare where normal keyboard
entries can produce varying symbols (same char number) just by changing the
cells font.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Hi

Thanks again. I actually meant the field code numbers. I found the 0176
number for the degree symbol just wondered if there was a place I could find
numbers for other symbols.

thanks
alison

 

[Dave Peterson]

In xl2002+
Insert|symbol
Select a character
Look at the bottom of the dialog.
You'll see the ascii codes (in hex or decimal--your choice)

Hi

Thanks again. I actually meant the field code numbers. I found the 0176
number for the degree symbol just wondered if there was a place I could find
numbers for other symbols.

thanks
alison

 

[David McRitchie]

Hi Alison,
see
Font Tables as Rendered by your browser
http://www.mvps.org/dmcritchie/rexx/htm/fonts.htm

If your browser is Internet Explorer you should be able to use
the table as seen. If you use Firefox you would have to modify
your character tables for Firefox to use Fonts installed by
MS Office.

Also see some other tables and tips such as setting up CharMap
in your menu or toolbars.
Symbols for HTML and Excel use
http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Hi

Thanks again. I actually meant the field code numbers. I found the 0176
number for the degree symbol just wondered if there was a place I could find
numbers for other symbols.

thanks
alison

 

[alistew]

this is great.

thanks so much

alison

Hi Alison,
see
Font Tables as Rendered by your browser
http://www.mvps.org/dmcritchie/rexx/htm/fonts.htm

If your browser is Internet Explorer you should be able to use
the table as seen. If you use Firefox you would have to modify
your character tables for Firefox to use Fonts installed by
MS Office.

Also see some other tables and tips such as setting up CharMap
in your menu or toolbars.
Symbols for HTML and Excel use
http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm