Parsing a alpha character out of a cell

[Lram]

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

 

[Lilliabeth]

Is it always one character?

Is the one character always at the right (end) of the entry?

 

[Lram]

Yes, it is always a single alpha character (Caps), and always appende
to the numeric value as 99X

 

[Lilliabeth]

=left(a1,len(a1)-1)

 

[Lram]

Lilllabeth,

Thanks, that works great! Now I must read up on that function.

 

[Lilliabeth]

Great! Read up on both functions - Left and Len. Look at the Right
function, too.

 

[Ron Rosenfeld]

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

 

[L. Howard Kittle]

If the values need to be numeric, you may want to do this to convert back to
numbers.

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

HTH
Regards,
Howard