Results 1 to 3 of 3

Thread: Add double quotes in IP addresses

  1. Dec 19th, 2018, 07:15 AM #1
    tmealha
    tmealha is offline

    Thread Starter
    New Member
    Join Date
    Oct 2018
    Posts
    11

    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.
    Reply With Quote Reply With Quote
  2. Dec 19th, 2018, 11:06 AM #2
    jdc2000
    jdc2000 is online now
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,525

    Re: Add double quotes in IP addresses

    Works fine for me. Post the contents of cell A1 in your sheet.
    Reply With Quote Reply With Quote
  3. Dec 19th, 2018, 12:15 PM #3
    tmealha
    tmealha is offline

    Thread Starter
    New Member
    Join Date
    Oct 2018
    Posts
    11

    Re: Add double quotes in IP addresses

    Thanks jdc2000, I had a problem with the format of the cells.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width