I import a table from sql server to Excel occassionaly,
I need to format one column in Excel file.
For example, I need to replace numbers in the column with a text,
with weekly, 1 with daily, 16 with monthly etc, 4 with daily etc,
Everytime I get the new file, I have to do it use replace dialoge bo
on the edit menu to do all the replace,
Are there some easy ways to do this, or at least I can save thos
functions so that later I can use it again, instead of doing replac
for each one manually.
Thank
--
xca
-----------------------------------------------------------------------
xcao's Profile:
http://www.excelforum.com/member.php...fo&userid=1453
View this thread:
http://www.excelforum.com/showthread.php?threadid=26322