| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting the number of letters in a cell | Excel Discussion (Misc queries) | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
| How to delete blank rows | Excel Discussion (Misc queries) | |||
| Delete space | Excel Discussion (Misc queries) | |||
Linear Mode
