I have a huge spreadsheet with lists of personal details, names, addresses etc etc
Each person also has a unique id number and this is in the format of xx-yy-zzzz where x,y and z are numbers.
xx is store identifier number
yy is store employee number
zzzz is the customer number
I want to sort all the data in customer number, I know how to normally do Data, Sort but how do I get the spreadsheet to basically ignore the xx-yy- and just sort based on the zzzz?
Hope that makes sense and that someone can help as this is tonight's homework!!
Cheers
|