Delete all letters?

[jeremy via OfficeKB.com]

I have project numbers that also have letters. How would I assign all
project numbers less than 4000 the leter "S"--here's a sample of the
column. The numbers great than 4000 get one of four letter categories...

4110
1022
SK00
KR00
WS00
4093
4120
4121
4116
4093I
4093HB
0918
1035

 

[bigwheel]

In a spare column enter the code =IF(A1<4000,A1&"S",A1) and copy it down as
far as you need.

 

[Don Guillett]

A bit more clarification of what it will look like, and where.

 

[CLR]

Maybe put this in B1 and copy down..........

=IF(ISERR((RIGHT(A1,4)*1)),A1,IF((RIGHT(A1,4)*1)<4000,A1&"S",A1))

It will turn 0918 into 0918S
It will turn 1022 and 1035 into 1022S ad 1035S
It will leave everything else in the sample column as-is.....

Vaya con Dios,
Chuck, CABGx3