Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate
I would like to concatenate the following cells, only if they don't contain
the word FALSE. H3 - Subordinations , H4 - FALSE H5 - FALSE H6 - Inventory Verification Cycle , H7 - FALSE H8 - FALSE H9 - FALSE H10 - FALSE H11 - FALSE H12 - FALSE H13 - FALSE H14 - Advance Rates , H15 - FALSE H16 - FALSE H17 - FALSE H18 - FALSE H19 - FALSE H20 - FALSE -- Barb |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate
The simplest way is to use the MCONCAT function from Morefunc add-in then you
can use =MCONCAT(IF(H3:H20=FALSE,"",H3:H20)) confirmed with CTRL+SHIFT+ENTER Get Morefunc here http://xcell05.free.fr/ otherwise you need either one very long formula or a series of formulas, one in each row "Barb Miles" wrote: I would like to concatenate the following cells, only if they don't contain the word FALSE. H3 - Subordinations , H4 - FALSE H5 - FALSE H6 - Inventory Verification Cycle , H7 - FALSE H8 - FALSE H9 - FALSE H10 - FALSE H11 - FALSE H12 - FALSE H13 - FALSE H14 - Advance Rates , H15 - FALSE H16 - FALSE H17 - FALSE H18 - FALSE H19 - FALSE H20 - FALSE -- Barb |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate
will this do it?
sub putemtogether() for each c in range("h3:H20") mystr="" if c<"FALSE" then mystr=mystr & c next c msgbox mystr end sub -- Don Guillett SalesAid Software "Barb Miles" wrote in message ... I would like to concatenate the following cells, only if they don't contain the word FALSE. H3 - Subordinations , H4 - FALSE H5 - FALSE H6 - Inventory Verification Cycle , H7 - FALSE H8 - FALSE H9 - FALSE H10 - FALSE H11 - FALSE H12 - FALSE H13 - FALSE H14 - Advance Rates , H15 - FALSE H16 - FALSE H17 - FALSE H18 - FALSE H19 - FALSE H20 - FALSE -- Barb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I concatenate a number and preserve the formatting? | Excel Worksheet Functions | |||
Concatenate Function | Excel Discussion (Misc queries) | |||
use formatting from source cell in CONCATENATE function | Excel Worksheet Functions | |||
Concatenate | Excel Discussion (Misc queries) | |||
Using Concatenate inside a vlookup | Excel Worksheet Functions |