Anything you copy/paste from a PWS data table will import into Excel as text. Excel is smart enough to put things in to rows and columns but the labels on things like temperature (°F) will cause it to be text and not a number.
However, all is not lost. If you search and replace " F" with nothing (i.e. blank, not a space) it'll get rid of all those and convert the temperatures to numbers. Be sure you copy the "space" before the F from a cell (it is not a space, it's what the ° turned into) or it won't work. Use "replace all".
[ You are not allowed to view attachments ]
Same process gets rid of the % on humidity, "in" on pressure, etc.