Results 1 to 5 of 5

Trouble finding specific word in text

Threaded View

  1. #1
    Registered User
    Join Date
    07-15-2019
    Location
    Rotterdam
    MS-Off Ver
    Office 365 (version 16.26)
    Posts
    11

    Trouble finding specific word in text

    I am currently working on an excel file and I am stuck with two formulas. Attached you can find a file in which you can find the formulas that are not working as I want, to be marked red (column E and N).

    First, I want the formula in column E to display a "1" if the cell in column C or D contains the text "0-jewel", "1-jewel", ..., "10-jewel". However, it displays a "1" for almost all observations because it counts, for example, "22-jewel" as "2-jewel". I want to overcome this problem, but I don't know exactly how to do this. I think the formula I use for columns E untill L is not the most efficient one either.

    Second, I have a similar problem regarding the formula in column N. Same problem, but now with milimeters (mm) instead of -jewels.

    Can somebody please help me rewrite this to an efficient formula?

    Kind regards,

    Bas van den Boomen
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trouble using macro to automatically send e-mail with specific word in cells
    By BioBCCK in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-15-2018, 10:49 AM
  2. Replies: 5
    Last Post: 02-26-2018, 12:18 PM
  3. [SOLVED] Macro for finding specific Word and Deleting it
    By Haidar123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-02-2014, 07:45 AM
  4. having trouble finding text within a text string HELP please
    By benakil in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-23-2013, 06:35 AM
  5. Finding a specific word within cell
    By Vespasian in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 01-26-2013, 05:57 AM
  6. Finding a specific word in a cell and executing an array
    By jgray152 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-10-2010, 07:49 PM
  7. Finding specific word in column
    By Phil #3 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-28-2005, 04: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1