If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
5th Char in a cell
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 |
#2
|
|||
|
|||
5th Char in a cell
Try
=MID(A1,5,1) -- Jacob "enna49" wrote: 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 |
#3
|
|||
|
|||
5th Char in a cell
You need the MID function. You'll find it in Excel help.
-- David Biddulph enna49 wrote: 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 |
#4
|
|||
|
|||
5th Char in a cell
Thank you, Thank you.
Sometimes we try to make things more difficult that what they are. Anne "Jacob Skaria" wrote: Try =MID(A1,5,1) -- Jacob "enna49" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|