copy text out of a range of cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark B - 06 May 2008 20:02 GMT

Is there a formula that will pull specific text from a range of columns in a
single row?

FOr example, I want to copy the words "Transportaion Form" into specific
cell assuming those words are located in Columns C:G of Row 3 .

If "Transportation Form" is not in any of those cells, then I don't want it
to pull anything.

Is this possible?

Reply to this Message

Pete_UK - 06 May 2008 21:58 GMT

Try this:

=IF(COUNTIF(C3:G3,"*Transportation Form*")>0,"Transportation Form","")

Hope this helps.

Pete

> Is there a formula that will pull specific text from a range of columns in a
> single row?
[quoted text clipped - 6 lines]
>
> Is this possible?

Reply to this Message

Mark B - 07 May 2008 02:49 GMT

ABSOLUTELY PERFECT! Thanks SO much!!!!!

> Try this:
>
[quoted text clipped - 14 lines]
> >
> > Is this possible?

Reply to this Message

Pete_UK - 07 May 2008 09:17 GMT

You're welcome, Mark - thanks for feeding back.

Pete

> ABSOLUTELY PERFECT! Thanks SO much!!!!!

Reply to this Message