Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Need help putting sort order back
Name: ismegordo Date: March 31, 2004 at 19:06:49 Pacific OS: WinXP Home CPU/Ram: 3.2 512Mb
Comment:
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.
Name: chnos Date: March 31, 2004 at 22:23:59 Pacific
Reply:
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.
Summary: Ok. I need help setting up my account on Outlook 6. I dont know what all the POP3,IMAP,and SMTP stuff is. I had my e-mail set up in Outlook before but I had to re-format and now I dont know what serve...
Summary: Hey, I am working on a quick spreadsheet for reporting for work, and everything works fine, except for 1 sheet, which i'm not sure how to do it! I'm not very advanced at excel, but i have been using V...
Summary: I am assuming that you are getting a dialog box telling you that the workbook contains macros. If you "tried" to write the macro, then you probably have at least one module saved in the VBA editor. Y...