Seperating first few variable length letters(alphas) from numerics

Hi all,
I have column A that contains mixed data, it could be several hundreds, thousands of rows.

1 12345
2 0943
3 FT9876VT4
4 BZZ3487
5 CAAE345732
6 YUV2456-56

I would like to process this column so that in column B it would just have the first alphas (however many they are) ignoring any other alphas in the cell, for instance ignoring the VT in cell A3 ...

1
2
3 FT
4 BZZ
5 CAAE
6 YUV

Column C would contain the first numeric after the first lot of alphas ...

1 1
2 0
3 9
4 3
5 3
6 4

And column D would contain whatever is left after the first lot of alphas ...

1 12345
2 0943
3 9876VT4
4 3487
5 345732
6 2456-56

I don't know if VB is required to do this or it can be done with formulas?
Any help with this would be gratefully received by this newbiw.
Thanks
Kayma

You could add the following VBA function and then use it in MID/LEFT/RIGHT functions to get the info you want

Function FirstNumeric(inString)
For x = 1 To Len(inString)
If (IsNumeric(Mid(inString, x, 1))) Then
    FirstNumeric = x
    x = Len(inString)
End If
Next x
End Function

ie Column B would have the following formula:

=IF(FirstNumeric(A1)<2,"",LEFT(A1,FirstNumeric(A1)-1))

Column C

=MID(A2,FirstNumeric(A2),1)

Column D

=IF(FirstNumeric(A2)<2,"",RIGHT(A2,LEN(A2)-FirstNumeric(A2)))