I have a spreadsheet containing weather data - the cells containing windspeed and wind direction contain a data flag in addition to the numeric value, example 90S for wind direction and 2.1S for wind speed. I wish to get rid of the alpha character so I can work with the numeric values.
How do I parse each cell to remove the alpha character(s)?
Bookmarks