Can I Find/Replace multiple items?
Posted by Jeremy on December 18, 2001 12:38 PM
I have a long list of formulas that use ID #s. See example:
NT.1999 = 7886 + 8776
I want to convert the ID numbers to the text that the ID number represents. The formula above should read:
SW Region = Portland + Seattle
I have a file that defines all the Regions with two columns:
Example: NT.1999, Total Region
I have another file that defines all the markets:
Is there any way to access these other lists? I know I could just do a replace all for each ID number, but with lists over 100 items this would take FOREVER.