Text Function

[pmari]

Hi Friends,

I am using TEXT Function in the adjacent column to separate First 5 or 6 or 7 Letters with Numbers.

Is it possible to alter the formula (or VBA Code) depends upon 5th or 3rd digit. Sample given below.


F010CEA45 =LEFT(B2,5)
F010CEB44 =LEFT(B3,5)
F010DSB42 =LEFT(B4,5)
F010TCB11 =LEFT(B5,5)
F010SFP11 =LEFT(B6,6) 5th Letter is "S"
F010SFR00 =LEFT(B7,6) 5th Letter is "S"
F010SFR22 =LEFT(B8,6) 5th Letter is "S"
F020SFR55 =LEFT(B9,6) 5th Letter is "S"
F020SFP58 =LEFT(B10,6) 5th Letter is "S"
F030LC781 =LEFT(B11,7) 3rd Digit is "3"
F030LC792 =LEFT(B12,7) 3rd Digit is "3"
F010ZA701 =LEFT(B13,5)
F010ZT854 = LEFT(B14,5)


Please look into this.

Many thanks in advance.