+ Reply to Thread
Results 1 to 3 of 3

how to ignore the text in cell

  1. 08-23-2017, 04:45 AM #1
    vaasto2003 is offline
    Registered User
    Join Date
    10-09-2013
    Location
    Doha
    MS-Off Ver
    Excel 2010
    Posts
    8

    how to ignore the text in cell

    Good Morning All,


    I want to paste the formula upon condition met. Whereas, the column heading "QTY" also considered as >0.001 and paste the formula in corresponding cell. How to ignore the text value

    Please Login or Register  to view this content.

    Thanks
    Reply With QuoteRegister To Reply
  2. 08-23-2017, 05:13 AM #2
    Stormin' is offline
    Valued Forum Contributor
    Join Date
    03-16-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    371

    Re: how to ignore the text in cell 

    Please Login or Register  to view this content.
    or

    Please Login or Register  to view this content.
    Design everything to be as simple as possible, but no simpler.
    Reply With QuoteRegister To Reply
  3. 08-23-2017, 08:41 AM #3
    vaasto2003 is offline
    Registered User
    Join Date
    10-09-2013
    Location
    Doha
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: how to ignore the text in cell

    Thank you Mr Stormin, It works fine.
    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] Ignore Text in a Cell and Sum Only the Values of the First 3 Non Zero Numbers
    By akurei in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 05-31-2017, 04:27 PM
  2. Macro ignore specific text in a cell
    By aarona in forum Excel General
    Replies: 1
    Last Post: 02-07-2017, 07:20 AM
  3. I want a formula to ignore text values in cell references
    By Russellrupert in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-05-2016, 03:53 PM
  4. Ignore text in cell for use of function but Still show the text in a VlOOKUP
    By Oscady in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-21-2015, 05:07 AM
  5. Can I choose a displayed text in a cell, and ignore the formula behind it?
    By Onyxalis in forum Excel General
    Replies: 3
    Last Post: 11-29-2013, 10:27 AM
  6. [SOLVED] Ignore Text in a Cell and sum only the Value
    By Rene777 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 04-11-2013, 05:14 PM
  7. Ignore text in a cell during formula usage
    By Solo Sails in forum Excel General
    Replies: 6
    Last Post: 06-28-2011, 12:17 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