Thread: function to get specified part of a cell contents

I hope someone can help... I have a column of about 100 cells containing 13 digit numbers. in the next column, i want to write and copypaste a formula that will select the first 6 digits of each 13 digit number and display these first 6 digits only. it must be possible, but i can't figure it out. no decimals involved.

If your 13 digit is in cell A1 , then type in cell B1 the following function :

=LEFT(A1;6)

or

=LEFT(A1,6)

dont know if you need a comma or a semicolon.Depends on the region i think.
See your helpfile for more info.
After that you can copy and pastespecial the values into another column.