Do same operation on an entire column and put the data in the col itself

  • Thread starter Thread starter som
  • Start date Start date
S

som

Hi,

I have a column,

A B C
=====

25,970.50
263
26,233.50
4,285.50
4,287.90

What i want to do is divide each cell in A by 10 and put the result in
A itself. Is there any way to do this other than first putting the
result in another column B and then copying it into A. I am sure there
would a simpler way to operate an entire range of cells with a single
operation/transformation.

Thanx in advance

~som
 
Try this:

Enter 10 in an empty cell
Copy that cell: Edit>Copy
Select the range of cells in question in column A
Then do: Edit>Paste Special>Divide>OK

Clear the 10 from the helper cell

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Applying a formula to an entire column 3
Summing several IF's in a column. 3
CF for specific ranges of time for an entire column 9
Dividing Worksheet into Two Columns 2
HDMI is a terrible format and I wish it never existed 2
Conditional Formatting an Entire document 1
Insert a function in an entire column 3

Back
Top