| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy text out of a range of cells
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy text out of a range of cells
Try this:
=IF(COUNTIF(C3:G3,"*Transportation Form*")0,"Transportation Form","") Hope this helps. Pete On May 6, 8:02*pm, Mark B wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy text out of a range of cells
ABSOLUTELY PERFECT! Thanks SO much!!!!! "Pete_UK" wrote: Try this: =IF(COUNTIF(C3:G3,"*Transportation Form*")0,"Transportation Form","") Hope this helps. Pete On May 6, 8:02 pm, Mark B wrote: 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy text out of a range of cells
You're welcome, Mark - thanks for feeding back.
Pete On May 7, 2:49*am, Mark B wrote: ABSOLUTELY PERFECT! Thanks SO much!!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy the contents of a range of text cells and paste into one cell? | Excel Discussion (Misc queries) | |||
| Copy certain range of cells | Excel Discussion (Misc queries) | |||
| How to I copy text from a range of cells to another single cell? | Excel Discussion (Misc queries) | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
| Copy cells into range of cells until cell change | Excel Worksheet Functions | |||
Linear Mode
