On Sat, 15 Oct 2005 10:53:43 -0500, Lram
wrote:


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)?

If the data flag is always there, and always a single character, then:

=--LEFT(A1, LEN(A1)-1)


--ron