iki
11-24-2008, 02:09 PM
Alright, I have asked a few times for various cell searches and hopefully this will be my last. I should have a clear understanding of how the formulas work so I can begin to start making my own instead of always asking for your help. So here goes
Thousands of entries in the following format: ESK1018, ESC1932, ESCG9923 All 7-8 digit codes. I am trying to turn this into multiple columns to organize all the data.
The first 3 digits are always letters and indicate what type of job it is. If the 4th digit is the letter R then it indicates that the job was a rebuild as opposed to a brand new job. Finally the 4-5th digit indicates what type of job, 1 = 100, 9 = 900
SKIP ESK
CAGE ECG
SKIP/CATE ESC
LOADING CHUTE ELC
MISC EMS
LOADING STATION ELS
HEAD SHEAVE EHS
CAR ECR
LEVELOK ELV
ENGINEERING EEN
CUSTOM MACHINGING ECM
I will have to separate these into 3 different columns. So for example
ESK1018 and ECGR9923 =
JOB TYPE TYPE OF JOB
SKIP New 100
CAGE REBUILD 900
Any help you can give me on how to create the formula or method to get what I need will be very much appreciated.
Thousands of entries in the following format: ESK1018, ESC1932, ESCG9923 All 7-8 digit codes. I am trying to turn this into multiple columns to organize all the data.
The first 3 digits are always letters and indicate what type of job it is. If the 4th digit is the letter R then it indicates that the job was a rebuild as opposed to a brand new job. Finally the 4-5th digit indicates what type of job, 1 = 100, 9 = 900
SKIP ESK
CAGE ECG
SKIP/CATE ESC
LOADING CHUTE ELC
MISC EMS
LOADING STATION ELS
HEAD SHEAVE EHS
CAR ECR
LEVELOK ELV
ENGINEERING EEN
CUSTOM MACHINGING ECM
I will have to separate these into 3 different columns. So for example
ESK1018 and ECGR9923 =
JOB TYPE TYPE OF JOB
SKIP New 100
CAGE REBUILD 900
Any help you can give me on how to create the formula or method to get what I need will be very much appreciated.