Hi all,

I've looked high and low for the answer to this but just can't find it.

I've got a whole heap of GPS waypoint data I have to manage each week. After bringing them into Excel I need to simply put one letter in front of the unique id numbers in one column. I can do it by changing the first cell and dragging it down but because the numbers are not always in sequence I need to be able to just highlight the whole column and somehow put a letter in front of each number in each cell WITHOUT losing that unique number.

Can anyone help this very frustrated Kiwi ??

Thanks,

Matt.