Add Data in Cell in double quotation

[Dina01]

Hello,

Can anyone please tell me how to add all the data in a spreadsheet in quotation.

For example if I have number 12345 in a cell I would like to be able to add that number in double quotation. Like this "12345".

I tried the following formula
=Char(34) & A1 & Char(34)
But keep on getting error #NAME?

I don't want to use the custom format, because I would have to use two diffrent format for the decimal number...

I want to use a formula.
Does anyone know how to do this..

Thanks

 

[Zathras]

Because the double quote is used as a delimiter, Excel requires two double quotes in a row to be identified as a double quote. In you formula, you need to quote the quote, so a total of four double quotes are required on each side of the number:

A1: 12345
B1: =""""&A1&""""

Hope that helps.

 

[PepeLeMokko]

Hello Dina01,
try the concatenate function, it will give you what you are looking for

 

[Dina01]

Thank you very much