|
Delete all letters?
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 |
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 |
Maybe put this in B1 and copy down..........
=IF(ISERR((RIGHT(A1,4)*1)),A1,IF((RIGHT(A1,4)*1)<4 000,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 "jeremy via OfficeKB.com" wrote in message ... 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 |
| All times are GMT +1. The time now is 07:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com