Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

There might be a non-printable character after each number. You can use the LEFT function to isolate the 6 digits in each cell on your first sheet. In a blank column on sheet 1, say, column F, enter the formula:

=LEFT(A2, 6)

Go to the handle of the cell with the formula and drag the formula down to the last row of data. Select the cells in column F, copy, paste special - values over the original data.