| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
extracting a number
I have a column (A) of 300+ rows, with 10 digits in each cell. I need to
remove the last digit of each cell. I tried =LEFT(A2,9) on column B and then copied the fomula to the last row, but when I deleted column A, coumn B gave me a #REF! error. Is there a way to convert those number in column B? Or another way to do this without the use of =LEFT function? TIA Hernan. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting the data according to the number of cell | New Users to Excel | |||
| Extracting number from Text and () | Excel Discussion (Misc queries) | |||
| Help!!! Extracting a number to line up with a different number | Excel Discussion (Misc queries) | |||
| Extracting a 'number' from text | Excel Discussion (Misc queries) | |||
| Extracting the number from a text | Excel Discussion (Misc queries) | |||
Threaded Mode
