Merge columns

W

wendy

I have 6 columns with 6 differents categories, I need to put them all in one
column. I went to CONCRENATE but couldn't do it.
Can someone please help me?
 
3

3C

You are correct with the function..You can bring up to 30 strings together.
Be sure to press tab to get the next string to pop up for you past String 3.
As well be sure to put a space between your categories by placing " " as a
text string. For example =Concatenate(a1, " ", b1, " ", c1,etc....
 
Top