Another wildcard question

[nitemask]

I've used the search and can't fins what I'm looking for. Here's the situation. I have multiple rows so I will use one row as an example for help.

Column A:B80Gr 20 2-- BB243W1

I want to create a formula that will search the text above, find the 80Gr and copy that to another column. The issue is that the Gr in Column A may be preceded by 2 or 3 numbers directly in front of the Gr. Any help would be appreciated.

=IF(ISNUMBER(FIND("???Gr",C159)),"???Gr")

I've tried using ***, and also tried using no quotes

 

[barry houdini]

Hello nitemask, welcome to MrExcel

Try this formula

=LOOKUP(1000,MID(C159,FIND("Gr",C159)-{2,3},{2,3})+0)&"Gr"

 

[nitemask]

That works perfectly. Thanks. I only have about 1600 rows to fix. This will help a lot.