Hi all, column A has 3312 entries (from A1 to A3312) and from each number I have to substract number 48. How can I do that for the whole column because I do not want to do it for each entry.

Thanks.

In column B cell 1 use the formula =A1-48

Then drag the formula down all 3312 rows.

Once you have all your subtractions done,

You need to change column B from a column of formulas to a column of real values,First, highlight column B from cell 1 to cell 3312,

then on the Task Bar,

Select: Copy

Select: Past Special,

Select: Values

Click: OKYou could, if you wished, paste the values to A directly but

I would advise you NOT to until you have checked everything

in column B and are sure it's what you want.

Then simply copy column B to AMIKE

2 other options: With a formula...

Enter =A1-48 in B1.

Hold your cursor over the lower right corner of B1 until you see the auto-fill plus sign.

Double click to auto-fill to the bottom of your list without having to drag.

Without a formula:Enter 48 in B1.

Double click the auto-fill handle to put 48 next to each cell in your list.Right-click the B above Column B and choose Copy.Right-click the A above Column A and choose Paste-Special.

Click the circle next to Subtract, then OK.Left-click the B and choose Clear Contents or Delete.

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

Very helpful. Thank you both!

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History