[CampusManager] An Easy way to export a client list into Excel

From: Mark Bauer <mbauer_at_skidmore.edu>
Date: Tue, 17 Feb 2004 16:01:44 -0500

I got bored during lunch - so....

If you go into client view

Go ahead and filter any way you want (I did one with both connected and
not connected - at risk)

When the list pops up, go to edit select all

Hit control c to copy

open up an excel spreadsheet

highlight whatever cell you want to start in and do an edit - paste
special - text

It populates your spreadsheet, already broken out into cells for you.

If you want to separate the registered from the unregistered, column A
has MAC address for unregistered, and User Name for registered. A very
easy sort.

This makes life easier when you don't have to type everything in by hand.

-- 
--
---- Mark
++++++++++++++++++++++++++++++++++
Mark Bauer
Network Administrator
Skidmore College
815 North Broadway
Saratoga Springs, New York 12866
Phone: 518-580-5996
email: mbauer_at_skidmore.edu
Received on Tue Feb 17 2004 - 21:19:21 EST

This archive was generated by hypermail 2.2.0 : Tue Jan 06 2009 - 20:00:03 EST