Combine data in different cells into one cell.

[Garu]

Hello Everyone.

Problem 1
I would like to know if anyone can help me find a formula. I have data on the following cells A3, B3, C3. I would like combine the information in those cells to cell D3. I have included an attachment of how I set it up. Please advise anyone



Problem 2
I have the following data in cells like show below:

Ford Mustang 2007
Ford Mustang 2008
Ford Mustang 2009
Ford Mustang 2010

I would like to combine the data on the 3 columns and 4 fours to show like the format below. I have included an attachment for this.

Ford Mustang 2007
Ford Mustang 2008
Ford Mustang 2009
Ford Mustang 2010
Ford Mustang 2007-2010

I appreciate any input from anyone. Thank you for your time and expertise.

[y_t]

Traditionally the formula is

Please Login or Register  to view this content.

, you may have to add a couple &" "& to get it formatted the way you like it or you could append a space to the end of each cell value