+ Reply to Thread
Results 1 to 14 of 14

How to find "$" in formula

  1. #1
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    175

    How to find "$" in formula

    Hello guys,

    My formula is "=+'Summary YTD'!$F$251"
    Is there any way to find the "$" in the above formula.?

    Please assist...

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    25,371

    Re: How to find "$" in formula

    I've moved your thread to the appropriate section, as it's not a Windows query.

    I don't understand what you mean by 'find' in this context. Please elaborate.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    Are you new to Power Query and don't know what to do with the code you've been given? Have a look here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    46,907

    Re: How to find "$" in formula

    Why exactly do you need to find the $? They are used to "absolute" or lock a cell so the reference doesnt change when it is copied.

    If you want to remove them, you could use Find/Replace
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    09-26-2018
    Location
    Canada
    MS-Off Ver
    365
    Posts
    1

    Re: How to find "$" in formula

    Do you mean you're trying to summarize only cells with $ present?

    Need more info on what you're trying to do, posting a screenshot would help.

  5. #5
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    175

    Re: How to find "$" in formula

    Dear therealgates,

    Ye... I need to summarize only cells with $ present.

    There are too many formulas in the sheet. Some contains "$" and some doesn't.
    So when I am copying my data to another place, the output goes for a toss.

    Finding cells which contains "$" is very very time consuming.

    Please assist.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    20,668

    Re: How to find "$" in formula

    Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution is also shown (mock up the results manually).

    3. Make sure that all confidential information is removed first!!

    4. Try to avoid using merged cells. They cause lots of problems!

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Glenn



  7. #7
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel365
    Posts
    2,211

    Re: How to find "$" in formula

    Assume that your formula is at A1

    =ISNUMBER(FIND("$",FORMULATEXT(A1))) will return True if A1 has $

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    46,907

    Re: How to find "$" in formula

    Bi_Ry, OP's version looks to be 2007/2010. Im not sure Formulatext is available in those (could be wrong)

  9. #9
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel365
    Posts
    2,211

    Re: How to find "$" in formula

    FDibbins,
    Yes Formulatext is available from 2013.

    Just to improvise, Copy formula to other column eg: C1 > Ctrl+H replace "=" with " " to force that cell to text then =ISNUMBER(FIND("$",(C1)))

  10. #10
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    848

    Re: How to find "$" in formula

    You can also investigate use of GET.CELL but tbh if you go that route you may as well use a UDF.

  11. #11
    Registered User
    Join Date
    08-23-2018
    Location
    UAE
    MS-Off Ver
    2013
    Posts
    32

    Re: How to find "$" in formula

    ctrl+~ to view the formula then fine $ sign
    hope this will help you

  12. #12
    Registered User
    Join Date
    04-15-2019
    Location
    usa
    MS-Off Ver
    2013
    Posts
    8

    Re: How to find "$" in formula

    Yes Formulatext is available from 2013.

  13. #13
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    25,371

    Re: How to find "$" in formula

    Welcome to the forum, Xfinitycable. Do you have a question for us? If so, please start a new thread.

  14. #14
    Registered User
    Join Date
    04-15-2019
    Location
    usa
    MS-Off Ver
    2013
    Posts
    8

    Re: How to find "$" in formula

    thank you AliGW

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1