finding one word from a list of cell that contain multiple sentences

[maulik1k]

Hello all,

I am pretty new this wanted to check if there is a way to find one or two words in a list of sentences. For example, cell A1 contains ="GE, Asset#06577, Eldon, MO " and cells B1:B2000 contain something like this


b1-GE, Lease, Asset#06577, Eldon, MO final pymt
b2- Lease, Store#000419, Clarkesville, GA
b3- Lease, Asset#004719, Little Rock, AR
b4- Bloomin Brands, Sublease, Greenville, SC
b5- GE. Sale, Asset#020696, Jacksonville, AL
b6- 7-Eleven, Store#22956, Midlothian, IL
b7 - Bloomin Brands, Sublease, Tampa, FL

what code or formula can i write to match the #06577 to B1 and return everything in that cell so ideally I would like to have ="GE, Lease, Asset#06577, Eldon, MO final pymt" this back.

Thanks in advance.

[mikeTRON]

Post a sample workbook.