Results 1 to 7 of 7

"Find and Replace" missing the ability to replace values?

Threaded View

  1. #6
    Registered User
    Join Date
    03-23-2013
    Location
    Frisco, Texas
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: "Find and Replace" missing the ability to replace values?

    I encountered a problem very similar. When I would try to "find and replace" a VALUE vs. a formula, I could not choose the "value" option. I found a link that said it could be because the sheet is protected, but my sheet is NOT protected. I am searching for the word ARCADIA with two trailing spaces. I want to replace it with ARCADIA and ONE trailing space. When I look for ARCADIA?? (using ? as a wildcard), and replace with ARCADIA and a space, it worked. But I am positive I have not had to use a wildcard in the past. I've done this type of search and replace tons of times. So still don't know why this happened, but at least its fixed.
    Last edited by avemaria0831; 06-05-2013 at 01:13 AM.

Thread Information

Users Browsing this Thread

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

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