ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Converting (https://www.excelbanter.com/excel-discussion-misc-queries/210039-converting.html)

Excel Help Needed![_2_]

Converting
 
I have a document I put into Excel from MYOB, but I need it to be in a
worksheet format ( with columns and what not) Then, I also need too ssort it
be zip code from smallest to largest, starting with 1. How do I do those two
things? The address list I want to sort also has names, so when I go to sort
it, it does it be name. I need to sort it be zip code. PLEASE HELP ASAP.

Thanks

Shane Devenshire[_2_]

Converting
 
Hi,

What program is the file in? If your data is in a Word table, just select
the entire table and copy it, move to Excel and paste it.

put your cursor in the Zip code column and click the Sort Ascending toolbar
button on the Standard Toolbar.

If this helps, please click the Yes button

"Excel Help Needed!" wrote:

I have a document I put into Excel from MYOB, but I need it to be in a
worksheet format ( with columns and what not) Then, I also need too ssort it
be zip code from smallest to largest, starting with 1. How do I do those two
things? The address list I want to sort also has names, so when I go to sort
it, it does it be name. I need to sort it be zip code. PLEASE HELP ASAP.

Thanks



All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com