Text Formula Question

H

Hittin_Provs

In COL A, I have a list of 2 and 3 digit charactors. I would like to
seperate each string into the three adjacent columns.


KQ
AJs
TT
89s




KQ K Q
AJs A J s
TT T T
89s 8 9 s


I know that I can use the Left function for the first col, but cant
figure out how to get just the middle or third letters.


Thanks in advance,

Andrew
 
Top