+ Reply to Thread
Results 1 to 11 of 11

How to replace " from a Text?

  1. 05-02-2021, 07:54 AM #1
    Sybon is offline
    Registered User
    Join Date
    08-23-2020
    Location
    Dhaka
    MS-Off Ver
    2016
    Posts
    23

    Lightbulb How to replace " from a Text?

    Hi Wizards!!!
    Could u please help me to replace or clean " from a text?
    Reply With QuoteRegister To Reply
  2. 05-02-2021, 08:20 AM #2
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,015

    Re: How to replace " from a Text?

    Use Find & Replace.

    Find:"
    Replace: (leave blank)
    Last edited by AliGW; 05-02-2021 at 09:30 AM.
    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 05-02-2021, 09:10 AM #3
    Sybon is offline
    Registered User
    Join Date
    08-23-2020
    Location
    Dhaka
    MS-Off Ver
    2016
    Posts
    23

    Re: How to replace " from a Text?

    Thanks for ur quick help. Its not working
    Reply With QuoteRegister To Reply
  4. 05-02-2021, 09:27 AM #4
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.96 for Mac MS 365
    Posts
    8,691

    Re: How to replace " from a Text?

    Maybe you need to add a space in front of or behind or both and try again?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
  5. 05-02-2021, 09:30 AM #5
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,015

    Re: How to replace " from a Text?

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Reply With QuoteRegister To Reply
  6. 05-02-2021, 09:38 AM #6
    Sybon is offline
    Registered User
    Join Date
    08-23-2020
    Location
    Dhaka
    MS-Off Ver
    2016
    Posts
    23

    Re: How to replace " from a Text?

    Please have a look at the picture.
    Reply With QuoteRegister To Reply
  7. 05-02-2021, 09:42 AM #7
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,015

    Re: How to replace " from a Text?

    I will have a look at the workbook sample once you have posted it, NOT a picture!
    Reply With QuoteRegister To Reply
  8. 05-02-2021, 09:53 AM #8
    Sybon is offline
    Registered User
    Join Date
    08-23-2020
    Location
    Dhaka
    MS-Off Ver
    2016
    Posts
    23

    Re: How to replace " from a Text?

    Thanks for your kind help. Please visit the below G-Sheet link. At the output sheet I want to replace or clean " symbol

    https://docs.google.com/spreadsheets...#gid=509855905
    Reply With QuoteRegister To Reply
  9. 05-02-2021, 09:55 AM #9
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,015

    Re: How to replace " from a Text?

    Is this a Google Sheets query?

    If not, there are instructions at the top of the page explaining how to attach your sample Excel workbook.

    I won't follow external links to files - sorry. We have a perfectly good attachment option here.
    Reply With QuoteRegister To Reply
  10. 05-02-2021, 02:24 PM #10
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.96 for Mac MS 365
    Posts
    8,691

    Re: How to replace " from a Text?

    Ali’s suggestion should have worked whether there are spaces or not, here’s a suggestion, click in the cell and highlight what you want to remove then paste it into the find and follow the rest of Ali’s suggestion, see if that works.

    Otherwise as Ali recommend please upload a sample workbook.
    Reply With QuoteRegister To Reply
  11. 05-02-2021, 03:23 PM #11
    Rick Rothstein is offline
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,466

    Re: How to replace " from a Text?

    The problem appears to be that the cells you are trying to clear the quote marks from contain formulas that have pieced the text together from other locations where the text has quote marks around parts and/or all of the text there... and you are using the RIGHT function to create the values in the cells so I think your use of the RIGHT function is also grabbing the trailing quote marks. You either have to remove the unnecessary quotes from your original text data in the other locations or modify your formula to remove them afterwards.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find and replace all example of "To" but not change other text such as Toilet or Toll
    By BlueEagle in forum Excel General
    Replies: 5
    Last Post: 05-27-2020, 03:28 AM
  2. Prevent "Find and Replace" changing text format into date
    By ersyadiaz in forum Excel General
    Replies: 3
    Last Post: 09-24-2019, 01:11 AM
  3. Replace "Enter" from a VBA code to split wrapped text into different cells/rows
    By AliceDB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2017, 06:58 AM
  4. [SOLVED] Doing a Find/Replace not working if "replace" text is too large
    By ks100 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-05-2014, 02:52 PM
  5. [SOLVED] Find & Replace Function- how to change the needed text to "pop out"?
    By joannelittell in forum Excel General
    Replies: 5
    Last Post: 09-10-2013, 09:33 AM
  6. Macro to replace emplty cells with "(blank)" text
    By kapil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-03-2010, 03:04 AM
  7. Replace numbers with Text ("1" to "Apple", for example)
    By pilotwings64 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-07-2008, 06:56 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1