changing 'names'
Hi,
I use a set of string variables (ussually ppls names) in defining names, worksheet names, formula, base data, VB macro's etc. These string variables I am quite sure are unique. ie won't appear as a part of another word. I now want to make the whole spread sheet generic. Is there a way of doing a search and replace on the whole spreadsheet based on a search for the string that I want to replace? eg i may have the name jon in : worksheet name - jon worksheet and i may have the name jon in name : jon_list - refer to list a1 to n240 i may have the name jon in cell : a56 = "jon" and I want to change all the 'jon' strings into 'person_one' Thanks in advance... |
changing 'names'
For all name management use this superb addin: Name Manager from jan karel pieterse available from http://bmsltd.ie/MVP/Default.htm I've dabbled with a Name Editor of my own to allow changing names WITH automatic update of all formulas and names pointing to the name to be changed. It's not fool/bug proof but you may give it a go: available from http://members.chello.nl/keepitcool/download.html keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool wrote: Hi, I use a set of string variables (ussually ppls names) in defining names, worksheet names, formula, base data, VB macro's etc. These string variables I am quite sure are unique. ie won't appear as a part of another word. I now want to make the whole spread sheet generic. Is there a way of doing a search and replace on the whole spreadsheet based on a search for the string that I want to replace? eg i may have the name jon in : worksheet name - jon worksheet and i may have the name jon in name : jon_list - refer to list a1 to n240 i may have the name jon in cell : a56 = "jon" and I want to change all the 'jon' strings into 'person_one' Thanks in advance... |
changing 'names'
Thats perfect... thanks.
-----Original Message----- For all name management use this superb addin: Name Manager from jan karel pieterse available from http://bmsltd.ie/MVP/Default.htm I've dabbled with a Name Editor of my own to allow changing names WITH automatic update of all formulas and names pointing to the name to be changed. It's not fool/bug proof but you may give it a go: available from http://members.chello.nl/keepitcool/download.html keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool wrote: Hi, I use a set of string variables (ussually ppls names) in defining names, worksheet names, formula, base data, VB macro's etc. These string variables I am quite sure are unique. ie won't appear as a part of another word. I now want to make the whole spread sheet generic. Is there a way of doing a search and replace on the whole spreadsheet based on a search for the string that I want to replace? eg i may have the name jon in : worksheet name - jon worksheet and i may have the name jon in name : jon_list - refer to list a1 to n240 i may have the name jon in cell : a56 = "jon" and I want to change all the 'jon' strings into 'person_one' Thanks in advance... . |
All times are GMT +1. The time now is 04:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com