Find and replace in Excel
- This topic is empty.
March 25, 2013 at 3:19 am #68669
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.March 27, 2013 at 2:58 am #77509
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.March 27, 2013 at 3:19 am #77513
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.March 27, 2013 at 5:04 am #77515
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.March 27, 2013 at 2:11 pm #77517
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.March 27, 2013 at 2:16 pm #77519
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.March 27, 2013 at 2:21 pm #77520
“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.March 27, 2013 at 2:25 pm #77521
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.March 27, 2013 at 2:59 pm #77523
Please cheek-March 27, 2013 at 3:40 pm #77524
Thank you so so much. Torkona you make my task easier.
- You must be logged in to reply to this topic.