Sorry but i am stuck again

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
KODIAK BEAR said:
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.
Click to expand...

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
Click to expand...

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.
 
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.
 
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.
 
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
 
Back
Top