find to find a value in a row

[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.

 

[Frank Kabel]

Hi
maybe something like
=MATCH("serial number",A1:X1,0)
to return the column number for row 1

 

[Fab]

returns an #n/a

Hi
maybe something like
=MATCH("serial number",A1:X1,0)
to return the column number for row 1

 

[Frank Kabel]

Hi
in this case the wod 'serial number' is not within A1:X1

 

[RagDyer]

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

 

[Frank Kabel]

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

 

[RagDyer]

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

 

[Frank Kabel]

Hi
called QuoteFix. Benefits (fromt their help file):
- better quoting support
- and much more
(see http://flash.to/oblivion)

I just had to change my settings (didn't notice this behaviour before)