Excel Tips


Convert Multiline Data To Rows »

November 13, 2001

How to convert multiline data to rows.


Celect Random Numbers from a Column »

November 12, 2001

Select 5 random numbers from a column of 50 numbers.


Removing a Set Number of Characters From a Cell »

November 11, 2001

What I need to do throughout a big worksheet was to edit the cell, move the cursor to the end of the cell and then delete the last 4 characters if the characters.


Creating Page Breaks in Excel Automaticaly »

November 10, 2001

Trying to automatically put page breaks into a table in Excel.


Create a Unique Record Number »

November 9, 2001

We need to know how to set up a macro which will assign a unique invoice number.


Changing Numbers to Text »

November 8, 2001

Looking for a way to change text that looks like numbers to real text.


Parsing Date String »

November 7, 2001

I have the date 19960105 for example, but excel doesn't recognize it as a date without me having to put two slashes into it.


Click Through Ratio In Excel »

November 6, 2001

My website gets 300 hits each weekday and 100 hits each weekend day. After 4 weeks, I have received 7 orders. How do I calculate the click through ratio in Excel?


Sorting IP Addresses »

November 1, 2001

How to properly sort IP addresses in a column.