LinkBack URL
About LinkBacks
Hello!
I have a large table in which I want to replace some words. These words, and what I want them to be changed to, are in a separate table. Is it possible to ask excel to replace the words automatically, using the seperate table?
Hello!
I have a large table in which I want to replace some words. These words, and what I want them to be changed to, are in a separate table. Is it possible to ask excel to replace the words automatically, using the seperate table?
Hi,
Perhaps something like this. Assumes your range is A1:A100 and that your replacement table is in E1:F5 (with old and new words in the E and F columns respectively):
Regards
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks