Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

exporting disp hunt group data

Status
Not open for further replies.

Esmerelda

Technical User
Jun 20, 2002
105
US
We have been trying to figure out how to export hunt group data. We know how to export, but the hunt group data lends more to a .txt format, and, when forced to XLS or CSV, it placces all of the data in the first column. We would like to be able to place the member numbers and their names in a sortable format.

TIA,

Esmerelda
 
The solution is to first export data it as a .CSV file, make sure the .csv file you create use a format ( |or; or: separated)then open the same in excel, In the excel file use "text to columns" otpion under data menu, it will put all entries in separate cells & u can then sort it accordingly..

Cheers
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top