Results 1 to 6 of 6

Return Text From a Cell if It Contains One of Many Texts

Threaded View

  1. #1
    Registered User
    Join Date
    05-26-2021
    Location
    California
    MS-Off Ver
    MS 365
    Posts
    8

    Return Text From a Cell if It Contains One of Many Texts

    I have a list of campaigns that contain multiple texts in each cell. I want to pull out a word from the cell but the text is not always in the same position or always between the same characters.

    In the attached sheet I have 6 campaigns and I need to pull out specific words. If A2:A7 contains "Vegetable" then in column B I want it to say Vegetable, if in column A in says "Fruit", in column B write "Fruit", and so on.

    Should I create a list of what I want to extract and use that? Like Column C has a list of the text options I want to pull out (Vegetable, Fruit, Dairy, Grain, Cheese, Corn)

    Hope that makes sense.
    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. [SOLVED] Return all texts where the adjacent cell is >0
    By Enounce in forum Excel General
    Replies: 9
    Last Post: 03-06-2021, 03:21 PM
  2. Replies: 9
    Last Post: 05-03-2020, 03:01 AM
  3. Replies: 11
    Last Post: 04-09-2019, 09:50 AM
  4. Search for several texts and return a spesific text
    By mariur89 in forum Excel General
    Replies: 2
    Last Post: 11-24-2014, 07:37 PM
  5. Search for multiple texts in cell, return specific text
    By mariur89 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-24-2014, 06:43 PM
  6. Replies: 10
    Last Post: 09-18-2014, 09:36 AM
  7. Search the text in 3rd cell by using texts in 2 cells
    By Shinaj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-09-2014, 08:08 AM

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