This is an Excel question. I updated the picture, and it is clear. The following descriptions are just to help. Please provide formulas with the corresponding answer since I am studying it.

The following functions can be used

LEFT- LEFT(text,num_chars)formulas can be useful LEFT(C3,8)formulas

RIGHT-RIGHT(text,num_chars)formulas can be useful RIGHT(C4,6)useful

MID-MID(text,start_num,num_chars)formulas can be useful MID(C5,10,6)can be

LEN-LEN(text)formulas can be useful LEN(C6)22

FIND-FIND(find_text,within_text,start_num)formulas can be usefulFIND("u",C7,1)5- start_num indicates the digit from where the search should start Note, this formula is case sensitive

formulas can be usefulFIND("u",C8,6)17

TRIM-TRIM(text) formulas can be usefulTRIM(C9)formulas can be usefulRemoves any leading or trailing spaces

INFORMATION

CZQBD	Minor Feature Code defining an 6 Way Driver Seat
CZQBE	Minor Feature Code defining a 4 Way Driver Seat
CZQBH	Minor Feature Code defining an 2 Way Driver Seat
CZQBM	Minor Feature Code defining an 8 Way Driver Seat
CZQBU	Minor Feature Code defining an 10 Way Driver Seat
CZRBC	Minor Feature Code defining a 2 Way Passenger Seat
CZRBE	Minor Feature Code defining a 4 Way Passenger Seat
CZRBL	Minor Feature Code defining a 2 Way Sports Passenger Seat
CZRBT	Minor Feature Code defining an 8 Way Passenger Seat
CZRBV	Minor Feature Code defining a 6 Way Passenger Seat

J19 A R B C D E F G G H 1 J L 4. 4 Table 1 1 PREFIX 2 BASE EN 3 SUFFIX iu . 4 Base 5 RHSILHS 6 SEAT DRY/PAS 7 8 PART NUMBER DESCRIPTION DRIVE MINOR FEATURE CODES 5 5 6 9N62-B711M15-ADX FRONT SEAT ASY RHS COMP 4WAY P BBHBU BBHBZ CV7BC CWSBD CXSBB CZQBE CZ2BB DONBB HDEBD 3YW11 7 6N62-B711M16-BBFX FRONT SEAT ASY COMP LHS 4WAY - Q BBHDG CV7BC CWSBD CXSBC CZQBE CZ2BB DQNBC HDEBD 3D311 8 8 9N62-B711M15-BWDX FRONT SEAT ASY COMP RHS 4WAY Q CV8BC CWSBD CXTBC CZRBE CZ3BB CZ6BK DQOBB JCQBE 3ZB11 9 9N62-B711M17-BBDX FRONT SEAT 4WAY ASY COMP RHS P P CV7BC CWSBD CXSBB CZQBE CZ2BC DQNBB HDEBD 3YW11 10 8N62-B711M18-ACX 4WAY FRONT LHS SEAT ASY COMP Q BBHDG CV7BB CWSBD CXSBB CZQBE CZ2BC DONBB HDEBD 3K011 11 9N62-B711M18-CGCX 4WAY FRONT SEAT LHS ASY COMP Q BBHBU BBHBZ CV7BC CWSBD CXSBC CZQBE CZ2BC DONBC HDEBC 3K011 12 9N62-B711L 15-ADX FRONT SEAT ASY COMP RHS 2WAY Q BBHBU BBHBZ CV8BC CWSBD CXTBB CZRBC CZ3BB CZ6BK DQOBCJCQBE 3YW11 13 9N62-B711N15-BKDX RHS FRONT SEAT ASY COMP 6WAY P CV7BC CWSBD CXSBC CZRBT CZ2BB DONBC HDEBD 3ZB11 14 9N62-B711M18-WDX 4WAY LHS FRONT SEAT ASY COMP B BBHBU BBHBZ CV7BB CWSBD CXSBB CZQBE CZ2BC DONBC HDEBC 3YW11 15 8N62-B711N15-BIDX RHS FRONT SEAT ASY2WAY COMP P CV7BC CWSBD CXSBC CZQBH CZ2BB DQNBC HDEBC 32B11 16 17 Questions Question 1 18 Create a formula in column that extracts the PREFIX' only from column A Question 2 Create a formula in column that extracts the BASE only from column A 19 Question 3 Create a formula in column that extracts the SUFFIX only from column A 20 Question 4 21 22 Question 5 Question 6 23 YOU HAVE BEEN MISINFORMED! Apparently the BASE section of a part number can vary between 6 and 8 digits. (and is not always 7 digits as mentioned in the Definitions & Functions sheet). 7 Even though the above part numbers all contain 7 digit BASES create a formula in column that shows the BASE, but could also handle varying lengths. (You can re-use your formula from Question 2 if it already handles this scenario). The Vehicle Seat part numbers are defined as LHS or RHS . This information is shown within the Description in column. Create a formula in column that extracts the LHS or RHS text only. Using only the information in columns & , confirm in column whether each seat is a DRIYER or PASSENGER seat. (Note, no formulas required for this question) The string of MINOR FEATURE CODES shown in column helps to define the specifc usage of the relevant part number. If the string contains the MINOR FEATURE CODE [CZQ") eg. CZQBD, CZQBE.CZQBH, CZQBM or CZQBU, then the part number is a driver seat If the string contains the MINOR FEATURE CODE [CZR''] eg. CZRBC, CZRBE, CZRBL, CZRBT or CZRBV, then the part number is a passenger seat One Seat part number has a clear data error in Table 1. Highlight which part this is, in the appropriate cell in column. Now to fix the problem part number found in Question 7: Firstly, it's been confirmed that the data in column and column in Table 1 is definitely correct. Secondly, the sheet "Part Number Base Definition" shows how part number BASES are initially defined according to seat features. (Note, this is not always a 1to1 relationship) Using the above information, determine the correction that is required to fix the data error. Show this in column . Question 7 24 Question 8 25 26