Hi,

I am exporting information from an accounts package into Excel. One of the columns is currently imported as Nominal codes e.g. 7804 but i would like Excel to automatically change this to Plant Maint Reps & Rens. There are about 20 nominal codes that i use regularly that i would like to create some kind of code for so i dont have to make the changes manually everytime.

Any help would be greatly appreciated!!

Thanks,

Becky