Posted By: Anonymous
Yet another Excel question - 26/01/2015 16:34
I have a large number of rows with data that I would like enclose in speech marks.
e.g. I have the word Banana and I want it to end up as "Banana".
Concatenate gets all confused using the following formula:
=concatenate(""",A1,""")
As you would expect you end up with ,A1,. I have a work around using a single field with " then concatenating the multiple fields.
Is there anyway it can be done with one formula and just the source field?
e.g. I have the word Banana and I want it to end up as "Banana".
Concatenate gets all confused using the following formula:
=concatenate(""",A1,""")
As you would expect you end up with ,A1,. I have a work around using a single field with " then concatenating the multiple fields.
Is there anyway it can be done with one formula and just the source field?