I have observed wind direction in 16 point compass names and forecasted wind
direction points in the same text format. Can I use excel to create a 2 x 2
contingency table for this data?

The observed direction is one column next to the forecast.

Regards

FC