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

"jeremy via OfficeKB.com" wrote:

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

--
Message posted via http://www.officekb.com