XL 2000 take the last six characters

[~Alan]

Sorry if this is a duplicate I could not find the last one I sent

XL 2000 windows XP
Thank you RagDyer for this code
=MID($G$1,COLUMN(),-1,1) which works very well
I was wondering is there a way to take the last six characters
of a twelve  character cell 123450002S/F (example)
and seperate them into six seperate cells

P3  12345002S/F
in (F12) 1 (G12) 2 (H12) 3 ( I12) 4 ( J12) 5  (K12) 6
    (F13) 0  (G13) 0 (H13) 2 ( I13) S ( J13) /  (K13) F

Sorry if this is a duplicate I could not find the last one I sent
 

 

[JE McGimpsey]

Please don't post using HTML. It's impossible to read for those of us
who read news in plain text.