copy text out of a range of cells

M

Mark B

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?
 
P

Pete_UK

Try this:

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

Hope this helps.

Pete
 
M

Mark B

ABSOLUTELY PERFECT! Thanks SO much!!!!!


Pete_UK said:
Try this:

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

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top