Concatenation Help

[longview]

Is there a way to combine three columns into one completely new (fourth) column using concatenation wherein the results would look like this...?

Size, (Column_1_value); Color, (Column_2_value); Dimension, (Column_3_value)


The fourth column would simply be a combination of columns 1,2 and 3, along with the words "Size," "Color," and "Dimension".

Thanks so much!

 

[VoG]

Try

="Size, "&A1&" ; Color "&B1&" ; Dimension, "&C1

 

[longview]

Thanks VoG,

I tried it and got results, just not exactly what I'm looking for. I think I failed to properly explain what the end result should look like.

Here's what I have...
column 1 header is "Size"
Value of row 1 in column 1 is "Large"

Column 2 header is "Color"
Value of row 1 in column 2 is "Blue"

Column 3 header is "Dimension"
Value of row 1 in column 3 is "44"



Here's what I'm looking for...
So, in our new column 4 called "Attributes", I am looking for a formula that yields this (in row 1)...

Size, Large; Color, Blue; Dimension, 44

This formula could then be repeated all the way down the spreadsheet.

Thanks again.

 

[VoG]

Try like this

Excel Workbook
	A	B	C	D
1	Size	Color	Dimension
2	Large	Blue	44	Size, Large; Color, Blue; Dimension, 44
3	Small	Green	27	Size, Small; Color, Green; Dimension, 27
Sheet1

 

[longview]

That's it exactly!! You are a big help. Thanks so much.