+ Reply to Thread
Results 1 to 3 of 3

Ignore Italicized Text in Formula?

  1. 03-11-2014, 02:43 PM #1
    jamesjunkers
    jamesjunkers is offline
    Registered User
    Join Date
    02-20-2014
    Location
    New York, USA
    MS-Off Ver
    Excel 2010
    Posts
    15

    Ignore Italicized Text in Formula?

    Is there a way I can make my formula ignore italicized text?
    Reply With QuoteRegister To Reply
  2. 03-11-2014, 02:44 PM #2
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,663

    Re: Ignore Italicized Text in Formula?

    It must be done with VBA.
    Quang PT
    Reply With QuoteRegister To Reply
  3. 03-11-2014, 02:54 PM #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,050

    Re: Ignore Italicized Text in Formula?

    italics, bold, colors etc are all formatting, not data. regular excel formulas cannot "see" formatting and only works with data
    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. If then formula to ignore text after number
    By jakeh2475 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2012, 12:29 PM
  2. My italics are being un-italicized
    By coreynunlist in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2008, 01:35 PM
  3. I want a formula to ignore text
    By COZWV in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-20-2007, 09:27 PM
  4. Ignore Text for Formula
    By JohnHill in forum Excel General
    Replies: 2
    Last Post: 04-25-2006, 09:26 PM
  5. [SOLVED] Rows and Columns italicized
    By bradsdad25 in forum Excel General
    Replies: 1
    Last Post: 02-02-2005, 07:06 PM

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