Trying to extract Alphabetic Characters from a AlphaNumeric Special Character String

[RudeBoy]

Here is the Formula I have but I have added on to it the MID & Upper and it is not working.. Need some HELP.. Thanks

= '[WHITE-SHEET-S2008]QB'!B3&","&R10-SHEET-S2008]QB'=UPPER&MID(C3,1,MIN(FIND({"0","1","2","3","4","5","6","7","8","9","/"},C3&"0123456789/"))-1)

 

[RudeBoy]

I put in the wrong String.. Here is what I got So far..

= '[WHITE-SHEET-S2008]QB'(UPPER(MID(C3,1,MIN(FIND({"0","1","2","3","4","5","6","7","8","9","/"},C3&"0123456789/"))-1)))

I have it working within a normal Excel Tab Like this:
=(UPPER(MID(C3,1,MIN(FIND({"0","1","2","3","4","5","6","7","8","9","/"},C3&"0123456789/"))-1)))

Im just trying now to grab the input from another Excel Sheet WHITE-SHEET-S2008..

Help.. Thanks

 

[Leith Ross]

Hello RudeBoy,

Provide that the other sheet is in the same workbook then this should work...

=(UPPER(MID('WHITE-SHEET-S2008'!C3,1,MIN(FIND({"0","1","2","3","4","5","6","7","8","9","/"},'WHITE-SHEET-S2008'!C3&"0123456789/"))-1)))​