Excel 2007 : forumla for a range of cells that is variable

[jdischert72]

Since this is my first post, I don't want to do it wrong but this is what I'
m trying to accomplish.

Here is the example for the 1st formula in column B:

D=”James” E=”R” F=”Dischert” G=”Susan” H=”M” I=”Dischert” so
B=James R Dischert & Susan M Dischert

Or

D=”James” E=”R” F=”Dischert” and nothing in G,H, & I so
B=James R Dischert

in the 2nd formula for column C:

D="James" G="Susan" so
C= James & Susan

or
D="James" and nothing in G so
C=James

[protonLeah]

See Concatenation in Help. Post the formulas you tried if they don't work.

[jdischert72]

this is the formula that I have used so far but if the is no data in G, H, & I it still posts the & symbol to cell B

=CONCATENATE(D3, " ", E3, " ", F3, " ", "&", " ", G3, " ", H3, " ", I3)

I'm only needing the & symbol if there is data to pull from G, H, & I

[scwi]

Hi


I think what you want is this:


=CONCATENATE(D3, " ", E3, " ", F3, " ",IF(G3="","", "&"), " ", G3, " ", H3, " ", I3)


cheers!

[ConneXionLost]

How about this:

Please Login or Register  to view this content.

Cheers,

[protonLeah]

You can also use the concatenation operator, & as below. I selected the entire D column and named it hfirst, selected the entire E column and named it hmid, etc, etc. Then:

Please Login or Register  to view this content.