1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract Currency Symbol From An Currency Formatted Cell

Discussion in 'VBA Macros' started by 861171314, Mar 13, 2018.

  1. 861171314

    861171314 New Member

    Hello Dears
    I Want A Formula To Extract Currency Symbol From Cell
    This Formula Must Be Dynamically For All Symbol
    I Attach A Pic To Understand What I Want
    In This Picture In Cell B2 Formula Is " =Getcurrency "
    "=Getcurrency" Formula Is not A Vba Code
    I Think It Is A Dynamic Formula In Name Manager

    Attached Files:

  2. Chihiro

    Chihiro Excel Ninja

    It would help, if you upload sample workbook, rather than image.

    I'd imagine it's using legacy Exel4Macro function. =Get.Cell() to check for currency format.

    Have a read of link.
  3. 861171314

    861171314 New Member

    Hi Chihiro
    I Dont Have Workbook
    I Just Have A video And I Capture This Pic From That
  4. Chihiro

    Chihiro Excel Ninja


Share This Page