How to quote a quote with the CONCATENATE function in OOCalc

concatenation openoffice-calc
Richard H picture Richard H · Jan 27, 2010 · Viewed 95.9k times · Source

In OOCalc I want to use the CONCATENATE function to add quotes to each string in column A.

So in cell B1 I want to do:

=CONCATENATE("\"",A1,"\"")

OOCalc does not like this, or without the escaping backslash.

Does anyone know how to do this, or what an alternative method might be?

Answer

Andy Balaam picture Andy Balaam · May 20, 2010

This works for me:

=CONCATENATE("""",A1,"""")

Repeating the quotes escapes them (as it does in Visual Basic, I believe), so """" reads as: 'one quote to start a string, one escaped quote (""), then one quote to finish the string'.

Related questions

How do I concatenate two lists in Python?

How do I concatenate two lists in Python? Example: listone = [1, 2, 3] listtwo = [4, 5, 6] Expected outcome: >>> joinedlist [1, 2, 3, 4, 5, 6]

Read More
How to concatenate items in a list to a single string?

Is there a simpler way to concatenate string items in a list into a single string? Can I use the str.join() function? E.g. this is the input ['this','is','a','sentence'] and this is the desired output this-is-a-sentence …

Read More
Getting current date and time in JavaScript

I have a script that prints the current date and time in JavaScript, but the DATE is always wrong. Here is the code: var currentdate = new Date(); var datetime = "Last Sync: " + currentdate.getDay() + "/" + currentdate.getMonth() + "/" + currentdate.getFullYear() + " @ " + currentdate.getHours() + ":" + currentdate.…

Read More