Searching for text

[EBnLP01]

a1=BR549
a2="" (empty space)
a3="" (empty space)
a4=BR549

what i'm looking for, is a formula that will search these cells for a TEXT
value and then display that text. but where i'm having problems, is
depending on what else happens, the text "BR549" can be "M8FR2" or "G8E34".
but no matter what, the text within the column will always be the same. i
haven't mastered using wild cards, i always get an error when i try to use
them.

Any help is welcomed !!!

Thanks in advance
EBnLP01

 

[Rick Rothstein]

Does this do what you want (adjust the ranges accordingly)...

=INDEX(A1:A100,MATCH("*",A1:A100,0))

 

[EBnLP01]

You, my friend, are a freaking GENIUS !!!
i have been racking my head for hours on this.....thanks soooooooo much !!