Hello Experts,
I am a novice to excel and I have a very easy requirement. I have same text on 25 different sheet. I want to replace the number in text with the number corresponding to sheet number.
For example. The text in all the 25 sheets is "text01" it should be "text02" in sheet2, "text03" in sheet3 and so on till 25. Please keep in mind I want 01 to be replaced by 02, 03....11,12....,24,25 etc. not single digit "1" (should be "01")
For your reference I have attached an excel sheet with 6 sheet original excel sheet has 25 sheets and the length of the text is variable. Waiting for expert replies.
Thanks,
Amandeeo
Bookmarks