Now that john has told me what to do and it has worked for me and saved so
much time, please forgive me but i have 2 questions if nobody minds ?

1. I have some gaps. ie;

149 08 100
150
151 08 101
152 08 102 and so on.

How do i move 08 101 and the rest of 'A' column up please without wrecking
the work i have done ?(08 101 into the gap of 150) Belive me i am thick as 2
short planks where PC's are concerned.

2. Now, i have put numbers in column 'B' ie; 3001
3002
3003
and so on. Now, without wiping the numbers, how do i put D in front of all
of them please ? ie;
D3001
D3002
D3003

and before you all ask, yes i did check the help thing and a paperclip with
eyes popped up. when i asked it a question, the answer was way above me ! in
fact, that paperclip thing was as much use as a chocolate teapot !

Any help will be ever so much appreciated belive you me.

Thank you once again