How to add quote marks to words - concantonate?

[emjerum]

Hi,

I am trying to use concantonate to add quote marks to words.

For example I want Cardiff to be "Cardiff"

When I use concantonate and type in "" around the cell with the word I want to change the result is the same word without the quotes- no change. I know if I put quote marks in cells and cantonate this way it will work but I'm looking for a faster way without having to do this.

Any ideas would be appreciated.

Ed

 

[Oaktree]

Try either =""""&A1&"""" or =CHAR(34)&A1&CHAR(34)

 

[emjerum]

Thank you - it works

Thank you very much.