find to find a value in a row

  • Thread starter Thread starter Fab
  • Start date Start date
F

Fab

Im looking for a string (i.e. *serial number*) that could be anywhere in a
column of a row.

how could i do that.
 
Hi
maybe something like
=MATCH("serial number",A1:X1,0)
to return the column number for row 1
 
Unless Frank, it's *part* of a text string.

The OP's example included asterisks, so I would venture a guess that your
formula would satisfy him if it *did* include them.
=MATCH("*serial number*",A1:X1,0)
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------



Hi
in this case the wod 'serial number' is not within A1:X1
 
Hi
did not see the '*'. My Outlook Express add-in converted this to bold
text :-(
So thanks for stepping in :-)
 
What OE add-in are you talking about Frank?

Are you saying that there's something for OE that converts asterisks to Bold
format delimiters?

If there is something like that, why would you activate it, considering all
of what you do here?

Just wondering.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Hi
did not see the '*'. My Outlook Express add-in converted this to bold
text :-(
So thanks for stepping in :-)
 
Back
Top