Apply formula to the entire column

google-sheets array-formulas google-sheets-formula
skydv picture skydv · Jul 24, 2014 · Viewed 162.2k times · Source

I'm trying to recode all the zip code from Column A into Column B with the formula:

=TEXT(A1,"00000")

Like this:

enter image description here

I want every cell in Column B to be transformed using the formula above. But I have over 40,000 rows, so it is impossible to drag down the formula and apply it to the entire Column B.

Is there a formula I could use to solve this problem?

Answer

FredFury picture FredFury · May 7, 2015

I think it's a more recent feature, but it works for me:

Double clicking the square on the bottom right of the highlighted cell copies the formula of the highlighted cell.

Hope it helps.

Related questions

Counting number of occurrences in column?

What would be a good approach to calculate the number of occurrences in a spreadsheet column? Can this be done with a single array formula? Example (column A is input, columns B and C are to be auto-generated): | A | B | …

Read More
Selecting the last value of a column

I have a spreadsheet with some values in column G. Some cells are empty in between, and I need to get the last value from that column into another cell. Something like: =LAST(G2:G9999) except that LAST isn't a …

Read More
How do I combine COUNTIF with OR

In Google Spreadsheets, I need to use the COUNTIF function on a range with multiple criteria. So in the table below, I would need to have something like =COUNTIF(B:B,"Mammal"or"Bird") and return a value of 4. A |…

Read More