Thread: How do I get a cell to show the fifth character of another cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
OZDOC1050
 
Posts: n/a
Default 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?



Reply With QuoteReply With Quote