Concatenate

[davemcd29]

I have a set of questions in column A1 to A2 etc, answers are selcted in column B1 to B10 etc via a data validation list from another worksheet in the same workbook.

I want to use the concatenate or similar function to collect all of the answers into one single cell which i can then copy and paste into a separate program. I want the answers to be in a specific format however.

E.G.
I would like the following to be in one single cell

Name: (Answer in B1)
Team: (Answer in B2)

Group: (Answer in B3)
Action: (Answer in B4)

Result: (Answer in B5)

To include multiple futher text and answers etc

Is this possible?

I have used the concatenate function previously but only to collect the text, insert a commar or colen between said text or answers with spaces either side etc. This then was concatented into one cell as one long sentence or string rather than within a sepcific format. which is what i want now.

I am a basic user and any help would save me literally hours of googling and trial and error.

Thank you in advance

Yours hopefully

Dave

 

[Muhammad_Usman]

Re: Concatenate Help!

I have a set of questions in column A1 to A2 etc, answers are selcted in column B1 to B10 etc via a data validation list from another worksheet in the same workbook.

I want to use the concatenate or similar function to collect all of the answers into one single cell which i can then copy and paste into a separate program. I want the answers to be in a specific format however.

E.G.
I would like the following to be in one single cell

Name: (Answer in B1)
Team: (Answer in B2)

Group: (Answer in B3)
Action: (Answer in B4)

Result: (Answer in B5)

To include multiple futher text and answers etc

Is this possible?

I have used the concatenate function previously but only to collect the text, insert a commar or colen between said text or answers with spaces either side etc. This then was concatented into one cell as one long sentence or string rather than within a sepcific format. which is what i want now.

I am a basic user and any help would save me literally hours of googling and trial and error.

Thank you in advance

Yours hopefully

Dave

Please Post your desired Result in tabular form for batter understanding.

 

[jtakw]

I have used the concatenate function previously but only to collect the text, insert a commar or colen between said text or answers with spaces either side etc. This then was concatented into one cell as one long sentence or string rather than within a sepcific format. which is what i want now.

Hi,

Sounds like you already answered your own question...or I'm not understanding correctly:

Book1
	B	C	D
1	John Doe		Name: John Doe, Team: USA, Group: Doubles, Action: Tennis, Result: Win
2	USA
3	Doubles
4	Tennis
5	Win
Sheet175

Cell Formulas
Range	Formula
D1	=CONCATENATE("Name: ",B1,", Team: ",B2,", Group: ",B3,", Action: ",B4,", Result: ",B5)

 

[davemcd29]

Hi,

Apologies.

I am ok with the concatenate as you describe but instead of simply punctating the concatenated data i wanted some of the date to appear on new lines or paragraphs etc.

	B	C	D
John Doe	Name: John Doe Team: USA Group: Doubles Action: Tennis Result: Win
USA
Doubles
Tennis
Win

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet175​

I hope that makes sense?

Dave

 

[Peter_SSs]

Try this in D1 and set the formatting of D1 to 'Wrap Text'

Excel Workbook
	B	C	D
1	John Doe		Name: John DoeTeam: USAGroup: DoublesAction: TennisResult: Win
2	USA
3	Doubles
4	Tennis
5	Win
Concatenate