Excel concatenation quotes

I'm trying to concatenate several fields and want certain fields to start and end with quotes ("....."). When I put a cell (B2) inside this, the cell (B2) is shown as plain text with quotes around it.

CONCATENATE("""B2""") -> "B2"

CONCATENATE("""B2""") -> "(whatever is in cell B2)"

Answers


Try this:

CONCATENATE(""""; B2 ;"""")

@widor provided a nice solution alternative too - integrated with mine:

CONCATENATE(char(34); B2 ;char(34))

Need Your Help

Debugging 500 Response for Create Sales Receipt Through API Explorer

intuit-partner-platform quickbooks-online

I've been developing an IPP application using the PHP devkit. I've been using the XML returned from the $object->asIDSXML() method to debug my objects through the API Explorer. Within the API Expl...

Display Count Down Timer in label

ios nsdate nsdateformatter

I want to display a countdown timer. I have the start date and end date. I need to display the remaining time like