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?
|