View Full Version : Solved: Separation by comma
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
02-20-2006, 04:36 AM
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
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
02-20-2006, 05:19 AM
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,", ","")
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.