View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Jake
 
Posts: n/a
Default Can I automatically replace data when importing a text file?

I am importing data that has hundreds of numbers like 60003838, 60010813,
60003928, 60003895. I would like to know if there is a way to format the data
to change those numbers automaticaly to another value (names) every time I
import the data, or is there a way for me to replace all those values
automatically?