Hello. I am working on a .CSV stored document which has its rows growing day by day and will keep doing so for a long time. This file has numbers punched in coloumn A. The problem is, that the number in coloumn A is representing a sentence unique to this one number and it has a variation of numbers in it ranging from 1-3000. In other words, there are 3000 different sentences which are affiliated to 3000 numbers. As of now, the file are showing a number between 1-3000, we need Excel to convert the numbers to preset sentences. For instance:

Number 1 = Rainy day
Number 2 = Sunny day
Number 2176 = Fireplace

Is there a way to make excel automatically recognize the numbers and convert them into preset sentences? As the file is growing day by day, it will be to much work to use the replace tool every time. Thanks for any help.