Spreadsheet: 168822d1342600974-formula-for-validating-text-in-cell-with-pattern-of-numbers-and-letters-query
Sheet: Sheet1

 | For Alphanumeric in format 1234AB | For "_NEW"
BalanceSheet
FSH_6
FSH_CA
FSH_A1000
FSH_1000
100000
100001
100002
100003
100004
100005
100006
100007
100008
100009
100010
100011
100012
100013
100014
100015
100016
100017
100018
100019
100020
100021
100022
100023
100024
100025
100026
100027
100028
100029
100030
100031
100032
100033
100034
100035
100036
100037
100038
100039
100040
100041
100042
100043
100044
100045
100046
100050
100051
100072
100077
100078
100079
100080
100085
100095
100099
1000EA
1000EB
1000EC
1000ED
1000EE
1000EF
1000EG
1000EH
1000EI
1000EJ
1000EK
1000EL
1000EM
1000EN
1000EO
1000EP
1000EQ
1000ER
1000ES
1000ET
1000EU
1000EV
1000EW
1000EX
1000AA
1000EY
1000EZ
100081
100082
1000PA
1000PB
1000PC
1000PD
1000PE
1000PF
1000PG
1000PH
1000PI
1000PJ
1000PK
1000PL
1000PM
1000PN
1000PO
1000PP
1000PQ
1000PR
1000PS
1000PT
1000BA
1000BB
1000BC
1000BD
1000BE
1000BF
1000BG
1000BH
1000CU
1000CV
1000CW
1000CX
1000CY
1000CZ
1000CA
1000CB
1000CC
1000CD
1000CE
1000CF
1000CG
1000CH
1000CI
1000CJ
1000CK
1000CL
1000CM
1000CN
1000CO
1000CP
1000CQ
1000CR
1000CS
1000CT
100083
100086
FSH_1040
104000
1040EQ
1040ES
1040ET
1040EU
1040EV
1040AA
FSH_1050
105000
105001
105002
105003
105004
105005
105006
105007
105008
FSH_1051
105100
1051AA
FSH_1052
105200
105299
105201
105202
FSH_1053
105300
105302
105301
FSH_1001
100104
100100
100101
100108
100109
100111
100112
100113
100114
100115
100119
100102
100103
100105
100106
100107
100150
100151
100152
100153
100161
100162
100163
100164
FSH_1002
100200
100201
100202
100203
100204
100205
100206
100207
100208
100209
100210
100211
100220
100221
100222
100223
100224
100225
100226
100227
100228
100229
100230
100231
100232
100233
100234
100235
100236
100237
100238
100239
100240
100241
100242
100243
100244
100245
100246
100247
100248
100249
100250
100251
100252
100253
100254
100255
100256
100257
100258
100259
100260
100261
100262
100263
100264
FSH_A1100
FSH_1100
110000
FSH_A1200
FSH_1200
120000
120001
120002
120003
120004
120005
120006
120007
120008
120009
120010
120011
120012
120013
120099
1200AA
120014
120015
FSH_1201
120100
120101
120102
120103
120199
FSH_1205
120500
120501
120502
120503
120504
120505
120506
120599
1205AA
FSH_1210
121000
121003
121004
121005
121006
121007
121008
121009
1210BA
1210BB
1210BC
1210BD
1210BE
1210BF
1210BG
1210BH
1210BI
1210BJ
1210BK
1210BL
1210BM
1210EA
1210EB
1210EC
1210ED
1210EE
1210EF
1210EG
1210EH
1210EI
1210EJ
1210EK
1210EL
1210EM
1210EN
1210EO
1210EP
1210EQ
1210ER
1210ES
1210ET
1210EU
1210EV
1210EW
1210EX
1210EY
1210EZ
1210AA
121010
121011
121012
121013
121014
121015
121016
1210BO
121017
121018
121019
121020
121021
1210BP
1210BQ
1210BR
121022
121024
121023
121025
121026
121050
121051
121052
121053
121054
FSH_1211
121105
121123
121124
121100
FSH_1215
121501
121503
121504
121505
1215EA
1215EB
1215EC
1215ED
1215EE
1215AA
121506
121507
121508
121509
FSH_1216
121600
121601
121602
121603
121604
1216EA
1216EB
1216EC
1216AA
121605
121606
121607
121608
121609
FSH_1217
121701
121702
1217AA
[NAME]
FSH_1220
122000
122001
122002
122003
122004
122005
122006
122007
122008
122009
122010
122011
122099
1220EA
1220EB
1220EC
1220ED
1220EE
1220EF
1220EG
1220EH
1220EI
1220EJ
1220EK
1220EL
1220EM
1220EN
1220EO
1220EP
1220EQ
1220ER
1220ES
1220ET
1220EU
1220EV
1220EW
1220EX
1220EY
1220EZ
1220AA
1220BA
1220BB
122012
122013
122014
FSH_1225
122500
122501
122502
122503
FSH_1226
122600
FSH_1230
123000
123001
1230EA
1230AA
FSH_1235
123500
123501
1235EA
1235EB
1235EC
1235ED
1235EE
1235EF
1235EG
1235EH
1235EI
1235EJ
1235EK
1235EL
1235EM
1235EN
1235EO
1235EP
1235EQ
1235ER
1235ET
1235AA
123551
123561
123502
123503
FSH_1240
124000
124001
FSH_1245
124500
FSH_1246
124600
1246AA
FSH_A1300
FSH_A1310
FSH_1310
131000
1310EA
FSH_1320
132000
132001
132002
132003
132004
132005
132006
132007
132008
132009
132010
132011
132012
132013
132015
132016
132017
132018
1320AA
132019
FSH_1340
134000
134001
1340AA
1340EA
1340EB
FSH_2320
232099
2320EA
2320AA
FSH_A1390
FSH_1300
130000
130001
130002
1300P1
1300AA
1300EA
1300EB
1300EC
1300ED
1300EE
130015
130016
1300EF
FSH_1399
FSH_2300
230000
230099
2300EA
2300EB
2300EC
2300ED
2300AA
230001
230002
[NAME]
FSH_1400
140000
140001
FSH_1401
140100
FSH_1402
140200
FSH_1403
140300
140301
140302
140303
1403AA
140304
140305
140306
140307
140308
140309
140310
FSH_1404
140400
140401
140402
140403
140404
1404EA
1404AA
FSH_1405
140500
140501
140598
1405EA
1405EB
1405AA
140507
140506
140505
140504
140503
140502
140508
FSH_1406
140600
140601
140602
1406EA
1406EB
1406AA
140603
FSH_1407
140700
1407AA
140701
140702
FSH_1410
141001
141002
141003
141004
141005
141006
141007
141008
141009
141010
141085
141090
141091
141095
141098
141099
1410AA
FSH_1411
141100
141101
141102
FSH_1412
141200
FSH_1414
141400
FSH_1415
141500
141501
FSH_A1475
FSH_1475
147500
FSH_A1476
FSH_1476
147600
FSH_A1413
FSH_1413
141300
141301
FSH_OA
FSH_A1500
FSH_1500
150000
1500EA
1500EB
1500AA
1500EC
150011
150012
FSH_A1510
FSH_1510
151000
151001
151002
151003
151004
151005
151006
151007
151008
151009
151010
151011
151012
151013
151014
151015
151016
151017
151018
151019
151020
151021
151022
151023
151024
151025
151026
151027
151028
151029
151030
151031
151032
151033
151034
151035
151036
151037
151038
151039
151040
151041
151042
151043
151044
151045
151046
151047
151048
151049
151050
151051
151052
151053
151054
151055
151056
151057
151058
151059
151060
151061
151062
151063
151064
151065
151066
151067
151068
151069
151070
151071
151072
151073
151074
151075
151076
151077
151078
1510AA
FSH_1520
152000
152001
152002
152003
152004
152005
152006
152007
152008
152009
152010
FSH_1525
152500
152501
152502
152503
152504
152505
152506
152507
152508
152509
152510
152511
152512
152513
152514
FSH_1530
153000
153001
153002
153003
153004
153005
153006
153007
153008
153009
153010
153011
153012
153013
153014
153015
153016
153017
153018
153019
153020
153021
153022
153023
153024
153025
153026
153027
153028
153029
153030
153031
153032
153033
153034
FSH_A1800
FSH_1800
180000
180001
180002
180003
180004
180090
180099
1800AA
FSH_1801
180100
180101
180190
180199
1801AA
FSH_A1810
FSH_1810
181001
181002
181099
1810EA
181000_Total
181000_NEW
181000
1810AA
FSH_1811
181199
1811EA
181100_Total
181100_NEW