how to limit amount of numbers in cells in excel
Use a "helper" column which contains a text formula to parse out the
beginning characters.
Then you can sort on that helper column.
Data in A1 to A3000.
Enter this in B1:
=RIGHT(A1,6)
Drag down to copy,
OR
*Double* click the fill handle on B1, to *automatically* copy the formula
down Column B, as far as there is data in Column A.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jeff" wrote in message
...
I am trying to limit the amount of numbers that are in a cell. For example
I
have a cell that has this sort of number 1220H123456, and I only want to
have
the last six digits in that cell so I can sort in a numerical order. I
have
been deleting the first 5 digits manually, but that takes way too much
time
when the list has over 3000 rows. Any help would be wonderful!!!
Jeff
|