CHAR or CHR: is there code number for a downward arrow?

[itr674]

I've inserted a downward arrow in a cell and would like to see if there is a code number that I could use in a formula?

I used =CHAR() to find 255 characters, is that all there is?

 

[Richard Schollar]

Hi

That's the extended ASCII character set (so that is all there is using the CHAR function). Potentially you could experiment with various fonts (Wingdings comes to mind, for example) as I expect one of the Ascii characters (1-255) appears as a downwards arrow in that font set (can't be certain though - you'll have to test it out).

Hope this helps!

 

[itr674]

RichardSchollar--thanks, I will give that a shot...

 

[Scott Huish]

Wingdings 3 has quite a selection of arrows to choose from.

 

[Tom Urtis]

The dollar sign $ or the lower case letter i in WingDings 3 would most closely resemble the down arrow.

 

[jindon]

Don't know if this work on US version
try

Char(8749)

 

[Tom Urtis]

That will not work on US versions...the CHAR function does not extend to DBCS characters. It could be accomplished with VBA using ChrW:

ActiveCell.Value = ChrW(8595)

or

ActiveCell.Value = ChrW(8659)

depending on the desired look of the arrow.

 

[jindon]

That will not work on US versions...the CHAR function does not extend to DBCS characters. It could be accomplished with VBA using ChrW:

ActiveCell.Value = ChrW(8595)

or

ActiveCell.Value = ChrW(8659)

depending on the desired look of the arrow.

Thanks, Tom

It's good to know.