Hi there all, I am new at this So Here Goes: I have a list of peoples names, addresses, emails etc.. Now we tried to be clever and put the peoples surnames in order (oops were we wrong) so we put them in ascending order seeing that it seemed to of worked the spreadsheet was saved. It was the next day when we went to get a persons email address and for example we looked up John Smiths emails address and we wnt along to find his and it showed (for example) john.brown@isp.com.au, which we knew was wrong and after looking at the spreadsheet we saw that the only items that were in Alphabetical order was their surnames. Now here is the question: Is it possible to put back in the original order even though we have saved it, or do we need to retype it in again. Any help is appreciated. Thanks in advance ismegordo Take Care and God Bless ismegordo

thin u can have it by: duplicate ur whole list (to have a backup file just in case). copy column containin mail adresses . From it extract names (concatenate(left(cell ref;x characters) and so on . Next have a search in it to bring name / name in adress. If needed, send me a short sample, i can try for u.