Max,

That worked perfectly, now how do I return the 2nd instance?

Chad

"Chad Wodskow" wrote:

I have a row of 24 cells, some are blank and others have text. I am trying
to create a formula that returns the first instance of text being used. I
have tried using a match, but it gives me an error because I am trying to
pull text not a number.

thanks