data in cell
I have an excel spreadsheet, with 35000 records
there is a cell that i need to break that data to 3 different cell
first off, some of the data in that cell is
xxxxx-xxxxxx-xx-x and others are just mashed together xxxxxxxxxxxxxx
I need to break everything up. i need to have first 5 digits on one cell,
next 6 digits on one cell, next 2 digits on 1 cell and last digit on another
cell
please assist
|