Concatenate

[Barb Miles]

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

 

[daddylonglegs]

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

 

[Don Guillett]

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