Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel - option to extend function in cell to column
Excel should provide an option to extend a function entered into the first
cell in a column to the rest of the column. For example, say you have a column of five thousand text codes (A1 to A5000), each of which you want to truncate by two characters, you should be able to enter the formula for the first cell (B1) and opt for it to extend to B5000. Obviously you would not want it to extend further than that though. |
#2
|
|||
|
|||
kjoshua,
Excel does make it easy, though: enter your formula in cell B1, re-select B1, then double click the little square at the bottom right of the cell B1 (the autofill handle). Your cursor will change to a smaller black cross when it's in the right place. HTH, Bernie MS Excel MVP "kjoshua777" wrote in message ... Excel should provide an option to extend a function entered into the first cell in a column to the rest of the column. For example, say you have a column of five thousand text codes (A1 to A5000), each of which you want to truncate by two characters, you should be able to enter the formula for the first cell (B1) and opt for it to extend to B5000. Obviously you would not want it to extend further than that though. |
#3
|
|||
|
|||
Cannot improve upon Bernie's answer, but can offer an alternative if the
adjacent column has blanks. Select B1. Click in Name Box and enter B1:B5000 Enter Type your formula in B1 the hit CRTL + ENTER Gord Dibben Excel MVP On Wed, 17 Nov 2004 08:20:23 -0500, "Bernie Deitrick" <deitbe @ consumer dot org wrote: kjoshua, Excel does make it easy, though: enter your formula in cell B1, re-select B1, then double click the little square at the bottom right of the cell B1 (the autofill handle). Your cursor will change to a smaller black cross when it's in the right place. HTH, Bernie MS Excel MVP "kjoshua777" wrote in message ... Excel should provide an option to extend a function entered into the first cell in a column to the rest of the column. For example, say you have a column of five thousand text codes (A1 to A5000), each of which you want to truncate by two characters, you should be able to enter the formula for the first cell (B1) and opt for it to extend to B5000. Obviously you would not want it to extend further than that though. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Extract hyperlink string from excel cell | Links and Linking in Excel | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |