CODEWITHSUNDEEP
excelconcatenation
Vincent Tang
Vincent Tang

Reputation: 4170

Excel concatenating a " quotation in string

I have the following sample data,

enter image description here

I want to concatenate string1 and string2 to produce the concatenation result

"a" "b"

using the concatenate function

I did not find any the answer in official microsoft excel documentation

https://support.office.com/en-us/article/CONCATENATE-function-8f8ae884-2ca8-4f7a-b093-75d702bea31d

How would I do this in excel? Concatenate " quotation marks

Upvotes: 2

Views: 14252

Answers (1)

Polymer
Polymer

Reputation: 1108

I know it's not the prettiest solution but:

=CONCATENATE(CHAR(34) & A1 & CHAR(34), " " & CHAR(34) & B1 & CHAR(34))

or

=CONCATENATE(CHAR(34), A1, CHAR(34), " ", CHAR(34), B1, CHAR(34))

CHAR(34) can be used in place of ".

Edit: If you prefer, CHAR(34) can be replaced with """", four double quote marks - for the same effect.

Upvotes: 6

Related Questions