Help with what I believe is a simple excel formula!!!!!!!

R

RobertM

I just want to shave off the last two digits.

In a spreadsheet I want to turn this:

600134902
604117903
608313904

Into this:

6001349
6041179
6083139
 
W

widman

There are several answers depending on what you really want to end up with.
You could
1. Divide by 100 and not show decimals (or round to no decimals)
2. Same as above through past special
3. Use function: =left(a1,7) if your data was in A1 and you 7 digits.

And certainly a few others
 
S

SVC

If the first number is in cell A1, in cell B1 type =Left(A1,LEN(A1)-2). This
will cut off the last two digits, regardless of the length of the number in
cell A1. Copy the formula down as far as necessary. Then select the entire
column, copy, then Edit > Paste Special, and select Value. Click OK. This wll
remove the formula from the cells in column B.
 
S

SK

First if you have anything in the column to the right that you want to keep -
insert a new column. Then highlight only the data that you want to change
and click on the tool bar "Data" and use "text to columns" mark the "fixed
width" box - next button. on the data Preview screen left click and more the
line to the spot you want and click on next - then finish. That's it! -
delete the column that has the excess digits and you are done. Don't you
just love Excel???
 
Top