Put Symbol in Formula Bar

S

sambit

New member
Joined
Sep 3, 2014
Messages
143
Reaction score
0
Points
0
Excel Version(s)
Excel2007
Hi,
can we put any symbol in formula bar. if yes, then how ?

pl find attached image for your reference.
 

Attachments

  • symbol.JPG
    symbol.JPG
    26.7 KB · Views: 62
You can't enter the symbol directly.

You would need to find out the ANSI code for the symbol and enter it into the formula. Then change the font of the cell to wingdings or other symbol font.

e.g. =CHAR(215) will give you a left pointing arrow when changed to wingdings font.
 
suppose in Cell A1 = Time & in Cell B1 = ×

I want in Cell A2 result will be look like Time×

how to write formula to get above result.
 
=A1& " "& B1 is working for me where B1 is added by using the menu "insert symbol"
 
in cell B1=font of the symbol is wingdings. when we write formula the font is "Arial". After put formula the symbol is converted to font "Arial".
 
No, go to menu, INSERT, SYMBOL, choose whatever you want. DO NOT use font change and chr() method
 
As per your suggestion, I have gone through same process but the result look like below. pl find image.

working.JPG
 
You can't use windings font. Need aerial (or other basic font) to choose a symbol. (Yes I know this is a major limitation in symbols that can be displayed)
 

Attachments

  • wingdings.xlsx
    10.8 KB · Views: 73
You must log in or register to reply here.
Back
Top