Results 1 to 8 of 8

Thread: Put Symbol in Formula Bar

  1. #1
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007

    Put Symbol in Formula Bar



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    can we put any symbol in formula bar. if yes, then how ?

    pl find attached image for your reference.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	symbol.JPG 
Views:	48 
Size:	26.7 KB 
ID:	2746  

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    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.


  3. #3
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    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.

  4. #4
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    Excel Version
    Office 365
    =A1& " "& B1 is working for me where B1 is added by using the menu "insert symbol"

  5. #5
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    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".

  6. #6
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    Excel Version
    Office 365
    No, go to menu, INSERT, SYMBOL, choose whatever you want. DO NOT use font change and chr() method

  7. #7
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    As per your suggestion, I have gone through same process but the result look like below. pl find image.

    Click image for larger version. 

Name:	working.JPG 
Views:	36 
Size:	13.2 KB 
ID:	2772

  8. #8
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    Excel Version
    Office 365
    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)
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •