I hope you get this reply - it's been a while.

Assuming your column with wind direction on sheet1 (main data sheet) is
column F then in the column where you want the numerical representation you
need the formual =VLOOKUP(F1,$A$1:$B$16,2,0)

You could replace the 0 at the end with false - it is the same thing.

Hope this helps
Rowan

"Larry" wrote:

I'm sure this is a simple problem but I'm stupid. I have a
column with wind direction (N,NNE,NE...) and I need to convert
it to a numerical representation (0,22.5,45...). The spreadsheet
has about 20,000 rows so I need to automate this. I have a
mental picture how this needs to happen but I have no idea of
the syntax necessary.

Set a counter
Read a cell
If cell is empty quit
Select Case statement
Assign degree value to variable
Write variable to adjacent cell
Increment counter
Do again

Can anyone out there help me get started. I can get the select
statements but I have no idea how to programatically read and
write to cells.

Thanks,
Larry