+ Reply to Thread
Results 1 to 3 of 3

Find text characters within a formula

  1. 11-24-2017, 03:00 AM #1
    Wizards
    Wizards is offline
    Registered User
    Join Date
    08-30-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    78

    Find text characters within a formula

    Hi all,

    Is there a way of using the "find" function in Excel (or a comparable function) to pull out specific characters from a formula.

    Following is the formula:


    Please Login or Register  to view this content.
    The result of this particular formula is $91,003.

    The key characters in this formula for my purposes is "302" as this identifies the Business Unit.


    What I want is to have a formula in another cell which references this cell and tells me if the Business Unit being identified is "302" or another number.

    So far as I can determine the "find" function will only look at the result of a formula and not at the text that makes up the formula.

    Is it possible to look at the text within the formula?
    Reply With QuoteRegister To Reply
  2. 11-24-2017, 03:14 AM #2
    shukla.ankur281190
    shukla.ankur281190 is offline
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18604.20000) 64-bit
    Posts
    3,992

    Re: Find text characters within a formula

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Reply With QuoteRegister To Reply
  3. 11-25-2017, 01:28 AM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Find text characters within a formula

    Formulas only work on the value/answer shown in the cell, not the underlying formula.

    Why not put the "302" in it's own cell somewhere, then reference it?
    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
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find specific text and substitute characters
    By Ellen 2Excel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-15-2015, 05:50 PM
  2. Formula to find pattern of characters in text
    By igoodable in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-23-2014, 10:44 AM
  3. Find text between two special characters
    By djblois1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-25-2012, 01:11 PM
  4. Find 2 different characters in text string
    By shanevo6 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 06-30-2011, 04:54 PM
  5. Find a string of characters and then either keep the text or replace it
    By knitterkuba in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-15-2010, 05:15 PM
  6. find characters in text string
    By JAYB in forum Excel General
    Replies: 2
    Last Post: 09-02-2005, 03:05 AM
  7. [SOLVED] find text characters
    By Micayla Bergen in forum Excel General
    Replies: 2
    Last Post: 05-06-2005, 03:06 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1