WBXPress

You must be logged in to ask question. If you are New here, Register first (free). Then Login.

Find and replace in Excel

Home Forums Excel Utility Find and replace in Excel

  • This topic is empty.
Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #68669
    unknown
    Spectator

      Is it possible to use find all and replace all for unlocked cell in a sheet without changing locked cell. Let’s say in the sheet (TC certificate) there is school phone no 0123456789 and school reg no 12/45 in the upper portion. In the TC sheet there are some formulas like =+’admregister’!G12 (reference to another sheet named admregister) and so on. now I want to replace G12 to G124 for the automatic replacement of student name, gather’s name, addrress, admission no..so on by find 12 and replace with 74 then phone nos and school reg. no also changed to 07434567890 and 74/45. So again I have to change phone nos and reg no manually otherwise I have to find one replace with othes for sevaral times for every formulas. then I can print the TC certificate correctly.
      Please help me in this regard.

      #77509
      unknown
      Spectator

        If you don’t want to change in the whole sheet, then at first you select the desire cell(s) in which you want the changes, now apply Replace to all.

        #77513
        unknown
        Spectator

          Something going wrong. I’m uploading an attachment. In the TC certificate in formulas (*11) is used but when I want to replace 11 to 6 for another student then if I use replace all then red highlighted phone nos is also changed to 6. If I use replace sevaral times then it is ok.

          #77515
          unknown
          Spectator

            I’m try to remodel your sheet, just enter Sl. no. in S8 cell to get the desire figure, for printing purpose, please make fill color and text color of the cell S8 white.

            #77517
            unknown
            Spectator

              Thank you very much Torkona. I just have learned VLOOKUP funda. If I put the highlighted cell outside the printing area then no need of white font and white background.
              ******Another problem—In my TC certificate I used cell no address of Admregister sheet so in the cell L10, J12, A14 it is automatic gender (Son/daughter, He/She and his/her) but now it is showing wrong in your modified sheet. These are not changed accordingly. Please help me in that regard.

              #77519
              unknown
              Spectator

                Add 3 columns in first sheet, apply the formula (=IF((Admregister!O11=”boys”), “son”, “daughter” … etc) their, and in TC sheet apply VLOOKUP. Try it.

                #77520
                unknown
                Spectator

                  Please edit-
                  “bears a good moral character. I wish him for every success.”
                  When you print this type of sheet, some places will be blank and looks odd due to entry of formula in between the lines.

                  #77521
                  unknown
                  Spectator

                    Those 3 cells are in the TC sheet. If I add 3 columns more in the Admregister then it may be bulky enough. Is there any other way to solve my problem?
                    Thanks for checking my mistake. I have edited it.

                    #77523
                    unknown
                    Spectator

                      Please cheek-

                      #77524
                      unknown
                      Spectator

                        Thank you so so much. Torkona you make my task easier.

                      Viewing 10 posts - 1 through 10 (of 10 total)
                      • You must be logged in to reply to this topic.