+ Reply to Thread
Results 1 to 5 of 5

How to find and replace hidden single quote ? (This sign is single quote: ')

  1. #1
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,007

    How to find and replace hidden single quote ? (This sign is single quote: ')

    Greetings,
    1- Open an excel file and press Shift+2 into the A1 cell.
    2- Look inside of A1 cell and see there is a single quote sign there.
    3- Press Ctrl + F to find your entered single quote sign.

    Finding prosess is not working !
    Any support will be thankful...
    Last edited by HerryMarkowitz; 01-19-2014 at 03:34 PM.
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: How to find and replace hidden single quote ? (This sign is single quote: ')

    If you press Shift+2 in a cell, the @ sign will be entered in that cell, not the single quote.
    Gary's Student

  3. #3
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,007

    Re: How to find and replace hidden single quote ? (This sign is single quote: ')

    Quote Originally Posted by Jakobshavn View Post
    If you press Shift+2 in a cell, the @ sign will be entered in that cell, not the single quote.
    Because of keyboard differences

  4. #4
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: How to find and replace hidden single quote ? (This sign is single quote: ')

    the first ' in a cell acts as a notifier , to consider the values after that ' as a text, hence it does not show up in your find.
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

  5. #5
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,007

    Re: How to find and replace hidden single quote ? (This sign is single quote: ')


+ 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. Single Quote
    By Kinjalip in forum Excel General
    Replies: 4
    Last Post: 04-06-2006, 07:30 AM
  2. Replies: 3
    Last Post: 01-21-2006, 11:45 PM
  3. How can I get rid of the ' single quote sign in excel worksheet
    By Ivan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-21-2005, 01:05 AM
  4. Using VBA Replace function for single quote
    By galantis in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-05-2005, 09:05 AM
  5. What does SINGLE QUOTE mean before value in a cell?
    By surotkin in forum Excel General
    Replies: 2
    Last Post: 04-13-2005, 08:42 AM

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