+ Reply to Thread
Results 1 to 4 of 4

Remove quotes from links to excel

  1. #1
    Registered User
    Join Date
    01-25-2022
    Location
    Massachusetts
    MS-Off Ver
    365 Pro
    Posts
    7

    Remove quotes from links to excel

    I have a group of cells that I pasted into MS word as a link so that when I change a cell the word doc updates to match. This works good, I have a bulleted list that changes based on excel, but here is the issue: the first linked cell link starts with a quote (") and the last cell linked cell ends with a quote (").

    I tried combining all these into one cell with each reference separated by a line break (CHAR(10)) , but the same thing happens; the bullet list looks good except the list starts and ends with a quote.

    Any idea how to fix this issue?

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Remove quotes from links to excel

    Do you really need a new thread? Isn't this just part of the query you started yesterday?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    01-25-2022
    Location
    Massachusetts
    MS-Off Ver
    365 Pro
    Posts
    7

    Re: Remove quotes from links to excel

    This is a new and different issue. No VB or macro is used, just an issue with a bullet list link from excel to word.

    Thank you for checking in.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Remove quotes from links to excel

    OK - no worries.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Names.Add method creates named range using quotes - Need to remove quotes
    By AstToTheRegionalMGR in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-09-2016, 11:48 PM
  2. Remove quotes in text file after converting Excel to Text in VBA Access 2002
    By ucalcen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2014, 10:35 AM
  3. Replies: 0
    Last Post: 09-24-2012, 01:20 PM
  4. Remove some but not all links (Excel 2007)
    By shoopi in forum Excel General
    Replies: 3
    Last Post: 06-20-2012, 10:47 AM
  5. Single Quotes in HTML links
    By AndianAtWork in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-18-2012, 07:27 PM
  6. Remove text between quotes, variable length and number of quotes
    By JP Romano in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-14-2011, 10:40 AM
  7. Remove HTML links in excel
    By Carlton Patterson in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-17-2005, 08:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1