Concatenate with quotations

[Jon Melone]

I need to concatenate two cells and display with quotations. The cells are A1 and B1 and contain only text.

For example, the output in C1 should display quotations around the text in A1, concatenate a semi colon, concatenate B1 with quotes, and finally concatenate another semil colon. The output to the screen in C1 will show as (where A1 = text1 and B1 = text2): "text1";"text2";

The easy part is =A1&";"&B1&";". How do I display quotes within quotes? I'm vaguely familair with escape characters, but haven't found reference to them in Excel Help menu. Do I have learn how to use ASCII?

Jon

 

[VoG]

Try

=CHAR(34)&A1&CHAR(34)&";"&CHAR(34)&B1&CHAR(34)&";"

 

[Jon Melone]

Success!
I was reading in Help about holding the Alt key while typing the decimal code, which did not produce any result. I'll have to read-up on CHAR.

Thank you!
Jon

 

[T. Valko]

I need to concatenate two cells and display with quotations. The cells are A1 and B1 and contain only text.

For example, the output in C1 should display quotations around the text in A1, concatenate a semi colon, concatenate B1 with quotes, and finally concatenate another semil colon. The output to the screen in C1 will show as (where A1 = text1 and B1 = text2): "text1";"text2";

The easy part is =A1&";"&B1&";". How do I display quotes within quotes? I'm vaguely familair with escape characters, but haven't found reference to them in Excel Help menu. Do I have learn how to use ASCII?

Jon

Here's another one...

=""""&A1&""""&";"&""""&B1&""""&";"

 

[Jon Melone]

Hey, that works too! Actually, it's what I tried to do the first time, but couldn't keep track of my quotes. I see my error now. Thanks!

Jon

 

[T. Valko]

Hey, that works too! Actually, it's what I tried to do the first time, but couldn't keep track of my quotes. I see my error now. Thanks!

Jon

Yeah, it doesn't make sense, really.

To quote a quote you'd think that this is how you'd do it: " " ".

But, we're dealing with Excel!

So it's: " " " "

Thanks for the feedback!