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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Question 4
Scrabble Value calculation for Welsh words 0
match function with text and numbers 2
Help on finding first empty cell in multiplr ranges 2
Formula 2
auto populate selected cells 6
finding unique records 3
Someone locked you out of your BIOS, never ferr. 15

Top