Concatenate 2 cells and 2 strings

[Sal1]

I would like to concatenate Sheet2/A3, Sentence1, Sheet2/D12, and Sentence2 into one sentence with a space in between each string and then paste the new sentence into Sheet3/C4. Here is what I have but I need a lot of help. Can you lend a hand?

[SIZE=3][FONT=Times New Roman]Dim StringA As String, StringB As String,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]StringA = "Sentence1"<o:p></o:p>[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]StringB = "Sentence2"<o:p></o:p>[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]A3 &StringA & D12 & StringB [/FONT][/SIZE]

 

[GK039]

Hi,

Try in cell Sheet3/C4 something like

=Sheet2/A3 &" "& "Sentence1" &" "& Sheet2/D12 &" "& "Sentence2"

George

I would like to concatenate Sheet2/A3, Sentence1, Sheet2/D12, and Sentence2 into one sentence with a space in between each string and then paste the new sentence into Sheet3/C4. Here is what I have but I need a lot of help. Can you lend a hand?

[SIZE=3][FONT=Times New Roman]Dim StringA As String, StringB As String,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]StringA = "Sentence1"<o:p></o:p>[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]StringB = "Sentence2"<o:p></o:p>[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]A3 &StringA & D12 & StringB [/FONT][/SIZE]

 

[Scott Huish]

=Sheet2!A3 &" "& "Sentence1" &" "& Sheet2!D12 &" "& "Sentence2"

 

[Sal1]

Thank you GK039. I changed GK039 =Sheet2/A3 to =Sheet2!A3 and your formula did the trick. Thank you.

 

[Sal1]

SOLVED: Concatenate 2 cells and 2 strings

Thanks HOTPEPPER. Just what I needed. I appreciate your help.