|
| 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
February 9th, 2010, 04:38 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
February 9th, 2010, 04:54 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
February 9th, 2010, 04:57 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
February 9th, 2010, 05:01 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
|
Linear Mode
