Hi,

I have a column of data that consists of 2 and 3 digit numbers (eg 215 or 56), I need to add a prefix of EEL to all of them. As there are over 400 of them, they are all different and they are not concurrent (some numbers are missing) I cant just drag and fill.....

Any ideas?