Results 1 to 4 of 4

FIND and REPLACE

Threaded View

KWMKWM FIND and REPLACE 09-29-2010, 04:45 PM
DonkeyOte Re: FIND and REPLACE 09-29-2010, 05:23 PM
KWMKWM Re: FIND and REPLACE 09-30-2010, 12:56 PM
DonkeyOte Re: FIND and REPLACE 09-30-2010, 02:14 PM
  1. #1
    Registered User
    Join Date
    06-03-2010
    Location
    Tamarac, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    FIND and REPLACE

    I have a problem in which I must select a range and do a find and replace on the formula string ONLY, not the cell value. I am using Excel 2010 on a XP machine.

    As an example:

    A B C
    1 a1 .. a1
    2 .. .. ..
    3 99 .. ..
    Cell A1 is the value 'A1', C1 is a formula '=A1', A3 is a value '99'.

    What I want to do is select the range A1 thru C3, run a FIND & REPLACE (or equivelant), and in the box replace '1' with '3', thereby making the formula in C3 '=A3' and changing it's value as well but leaving the cell value in A1 alone.

    So that afterwards it would look like this.


    A B C
    1 a1 .. 99
    2 .. .. ..
    3 99 .. ..
    Find and replace claims to look at formulas but it also looks at cells without formulas as well.

    Is there any solution to this?
    Last edited by KWMKWM; 09-29-2010 at 04:47 PM.

Thread Information

Users Browsing this Thread

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

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