Categories
FAQ

Telephone Cabling Standards

It\’s always nice when there is a standard, at least up until Microsoft then attempts to create their own, competing one.. I keep wondering what the standard is for a few cables, so I\’m documenting them here..

With the clip at the top, telephone cables from left to right are: Black, Blue, White, Red.

All this and more is available from Access Communications

Categories
FAQ

Useful Excel Expressions

=UPPER( )
This function will change the case of a specified cell to upper case.

=LOWER( )
This function will change the case of a specified cell to lower case.

=PROPER( )
This function will change the case of a specified cell to title case (ie The first letter of each word in the cell will be capitalised).

Splitting Data

  1. Select the cells containing the data you want to split
    NOTE: Excel will split only one column at a time.
  2. From the Data menu, select Text to Columns…
    The Convert Text to Columns Wizard – 1 of 3 dialog box appears.
  3. Under Original data type, select Delimited
Categories
FAQ

Basic System Maintenance – Scandisk & Defrag

Q: The computer WONT DEFRAG. It gets up to 4% then starts again at zero. tried it 1/2 doz times and does the same thing each time HELP……

A: Does it scandisk? Scanning the disk and keeping it in good order is much more important than defraging it, though defrag is important too. The main reason I ask is that the first 7% of the defrag is actually checking the disk for errors.

The other thing to look for is other programs that are open that might be reading from or writing to the disk. Close down your virus checker and anything else you can, and then run a scandisk and then a defrag. If you have to, Ctl-Alt-Delete and End Task everything except Explorer and Systray and then try.