+ Reply to Thread
Results 1 to 2 of 2

How To Lookup Part of Text in a Cell

  1. #1
    Registered User
    Join Date
    05-16-2019
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    54

    How To Lookup Part of Text in a Cell

    Hi All

    This is my sample data and I've got so far but kinda stumped now.

    "Compan ABC Black Sapphire Metallic Spray Paint - 12.5ml
    Product Description

    £10.40"


    My Formula is: =CLEAN(MID(IFERROR(MID(A2,FIND("Compan",A2),56),""),1,56))

    and this duly extracts: Compan ABC Black Sapphire Metallic Spray Paint - 12.5ml


    However on my next line the sample data is:

    "Compan ABCD Quartz Grey Metallic Spray Paint - 150ml
    Product Description

    £10.40"


    and the same formula starts returning the main Description but then the words on the next line too - which I don't want.

    Is there any way to terminate the Formula when it goes past the next line?

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How To Lookup Part of Text in a Cell

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lookup to reference part of a string of text.
    By Cleric82 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-04-2017, 10:34 AM
  2. Lookup for Code that Corresponds to Part of string of text in a Cell
    By brandnew22 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-06-2013, 07:33 PM
  3. [SOLVED] Lookup function to return only part of the text of a cell
    By cpalmer72 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2013, 04:14 PM
  4. Replies: 5
    Last Post: 04-08-2012, 01:06 AM
  5. Lookup part of text in column of cells
    By cad1llac in forum Excel General
    Replies: 5
    Last Post: 09-04-2011, 04:29 AM
  6. [SOLVED] (v)lookup part of text in cell
    By Ted in forum Excel General
    Replies: 4
    Last Post: 07-24-2005, 06:05 AM
  7. msgbox to lookup part text any help pls
    By short_n_curly in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2005, 06:05 PM

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