How do I get a cell to show the fifth character of another cell?
 

I have a number in cell N7 which is 8 characters long. I am using =LEFT(N7,3)
to refer to the first 3 digits of that cell and =RIGHT(N7,3) to refer to the
last three digits. How do I get it to refer to the 2 center digits without
showing any of the rest of the number?

How do I get a cell to show the fifth character of another cell?
 

=MID(N7,4,2)

cheers
Pete
--
(][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][)
"dedsky" wrote in message
...
I have a number in cell N7 which is 8 characters long. I am using
=LEFT(N7,3)
to refer to the first 3 digits of that cell and =RIGHT(N7,3) to refer to
the
last three digits. How do I get it to refer to the 2 center digits without
showing any of the rest of the number?