5th Char in a cell

  • Thread starter Thread starter enna49
  • Start date Start date
E

enna49

Hi
I know this is simple, and I know I should know it, but I cannot get it to
work and I have searched Help and the answers seem more complicated than what
I really want.

I have a Col that can have a number of codes with varying lengths. What I
want to do is extract the 5(Fifth) Char from each Cell.
eg
ABCD
ABCDEFGH
ABCDE
ABCDEF
ABCDEFGHIJK

Thanking you once again
 
Thank you, Thank you.
Sometimes we try to make things more difficult that what they are.
Anne
 
Back
Top