Add double quotes in IP addresses

Hello guys,

I have a problem regarding to include a list of IP addresses in double quotes. When I try to do that with a formula (e.g. =CHAR(34)&$A1&CHAR(34)) it adds the quotes but removes the dot points. I guess that this can only be solved through a VBA script but I am a beginner in this field. Can someone help me please?

Thanks in advance.

Works fine for me. Post the contents of cell A1 in your sheet.

Thanks jdc2000, I had a problem with the format of the cells.