Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Alter numbers in a range of formulas (Excel 2002/2003)

    Hi

    I have a worksheet that has hundreds of rows similar to the one below, in this instance I have to change every instance of 13 to 14, is there a way to by selecting the whole range or do I have to do each cell individually, I can't remove the abosolute ref, even if I could the rows are not Contiguous for easy copying.


    A129 B129 C129 D129 E129 F129 G129
    ='Site List'!$AB$13 ='Site List'!$AC$13 ='Site List'!$AD$13 ='Site List'!$AE$13 ='Site List'!$AF$13 ='Site List'!$AG$13 ='Site List'!$AH$13

    H129
    ='Site List'!$AI$13

    Thanks in advance

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Alter numbers in a range of formulas (Excel 2002/2003)

    Select the range.
    Select Edit | Replace...
    Enter 13 in the 'Find what' box.
    Enter 14 in the 'Replace with' box.
    Click Options >>
    Make sure that 'Look in' reads Formulas.
    Click Replace All.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Alter numbers in a range of formulas (Excel 2002/2003)

    Hi Hans

    Thanks very much, that should speed up the job.


    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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