Assuming 149, 150, 151 and 152 are row header numbers and not part of column A
data.

Select column A and F5SpecialBlanksOK

EditDeleteShift cells up.

For second problem...........

In column C enter ="D" & B1

Double-click on fill handle of B1 to copy down.

Select column C and in place EditPaste SpecialValuesOKEsc.

Delete original column B


Gord Dibben MS Excel MVP

On Mon, 1 Oct 2007 06:13:00 -0700, KODIAK BEAR
wrote:

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