Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    search and replace with formatting (Excel 2003)

    I am deciphering a large spreadsheet done by someone else and would like to be able to search and replace cell addresses in formulas; e.g. C13 or $C$13 with a variable name such as Hmin where the min in Hmin is subscript. I'm also changing the formula to text so I can read it. Other than doing a search and replace and then individuallly changing the text, is there a way to keep subscript/superscript formatting in a search and replace?

    Thanks.

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

    Re: search and replace with formatting (Excel 2003)

    Formulas cannot contain formatting of individual characters.
    As far as I know, Replace cannot apply character formatting to the "replace with" text.
    You can write a macro that applies subscript to "min".

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: search and replace with formatting (Excel 2003)

    That's what I thought, but I wanted to check with people who know a lot more about Excel than I.Thanks.

Posting Permissions

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