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.
Re: Add double quotes in IP addresses
Works fine for me. Post the contents of cell A1 in your sheet.
Re: Add double quotes in IP addresses
Thanks jdc2000, I had a problem with the format of the cells.