Solved: Separation by comma

[SUJU]

Hi
I have the following scenario:
Col B2 = Banks
Col C2 = Investments
Col D2 = Diversified

I need a formula that will take the above data, and rewrite them all together in one cell in A2 as follows:
Banks,Investments,Diversified
There must be no space after the comma.

Hope thats easy to understand
Thanks
Suju

[Bob Phillips]

Hi
I have the following scenario:
Col B2 = Banks
Col C2 = Investments
Col D2 = Diversified

I need a formula that will take the above data, and rewrite them all together in one cell in A2 as follows:
Banks,Investments,Diversified
There must be no space after the comma.

Hope thats easy to understand
Thanks
Suju

=B2&","&C2&","&D2

[SUJU]

Thanks xld. That was exactly what i wanted.
As a matter of interest, what would the code be if the cell value is
consumer, cyclical
and i wanted to remove the comma and space between the two words?

Thanks again

[Bob Phillips]

Thanks xld. That was exactly what i wanted.
As a matter of interest, what would the code be if the cell value is
consumer, cyclical
and i wanted to remove the comma and space between the two words?

Thanks again

Assuming that the text is in A1, then you want

=SUBSTITUTE(A1,", ","")

[SUJU]

Thanks xld. You the man!