Excel Find Query

[rabso]

Good morning, I am struggling with the find function in excel. I have a string for example 112ABC325 in cell A1. I need to extract the ABC, now the ABC can be anwhere in the string.

This is what ive tried
IF(FIND(ABC,A1),ABC,"")
But everything comes as blank, ("") even though there is ABC in the string.

Any ideas?

Thank you
Richard Baker

 

[sh1pley]

You need to put ABD in speech marks

=IF(FIND("ABC",A1),"ABC","")

 

[rabso]

Sorry, I have tried that, and also tried referencing to a third party cell that contains the name. This is my running formula, so you can see.

=IF(FIND("Matt",C2,1),$I$1,IF(FIND("Gloss",C2,1),$J$1,""))

The value of C2 is
165 307 Core Gloss

So the formula should return Gloss, but it returns #Value

 

[sanrv1f]

Try this

=IF(ISNUMBER(FIND("Matt",C2)),$I$1,IF(ISNUMBER(FIND("Gloss",C2)),$J$1,""))

note that, FIND is a case-sensitive function

 

[rabso]

Brilliant, thats great thank you :D