Sorry but i am stuck again

[Guest]

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

 

[Gord Dibben]

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

Select column A and F5>Special>Blanks>OK

Edit>Delete>Shift 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 Edit>Paste Special>Values>OK>Esc.

Delete original column B


Gord Dibben MS Excel MVP

 

[David Biddulph]

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.

Select the cells for the gap into which you want to move things up. Right
click/ Delete .../ Shift cells up.

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

In another column type the formula ="D"&B1 and copy down. If you want to
replace the original data you can select your new cells, Copy, Select your
original data, Edit/ Paste Special/ Values, then you can delete the new
cells.

 

[Guest]

Good afternnon Gord.

Thank you for your help.

The first answer you gave to my question helped. Brilliant, thank you.

But, number 2 i have been trying for ages and its not working.

I type in ="D" & B1 as you say and follow the rest of your instructions but
all i get is D and no numbers ?

Any idea why please ?

Many thanks for helping me.

 

[David Biddulph]

You've replied to your own post, not to Gord's. Reply to Gord's message,
and quote the relevant parts, and tell us at what stage you had problems.

 

[Gord Dibben]

I assumed your numbers in Column B started at B1.

The formula ="D" & B1 is to entered in C1 and copied down column C.


Gord