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

  Jacob Skaria replied to enna49

Try

=MID(A1,5,1)

--
Jacob

  David Biddulph replied to enna49

You need the MID function.  You'll find it in Excel help.
--
David Biddulph

  enna49 replied to Jacob Skaria

Thank you, Thank you.
Sometimes we try to make things more difficult that what they are.
Anne

Win7 VirtualStore Weirdness with Excel 2002 and earlier Excel I thought I'd share a weird experience I had today in case it saves installer for it - - which registers it as an add-in for all installed versions of Excel - - and tested it. Fine in Windows 2000 in all installed versions of Excel. Boot to Windows XP, fine there too. Boot to Windows 7. Fine in Excel 2010, 2007, and 2003. But Excel 2002 and 2000 were still loading the old version of the add-in. I uninstalled the add-in, made sure it was gone, and reinstalled it. Same problem in Excel 2002 and earlier; still works fine in Excel 2003 and later. I opened the VB editor in Excel 2003 and in Excel 2002

Pb de recalcul Excel Bonjour, J'ai un problème de recalcul de ma feuille excel. J'importe une colonne qui se retrouve en texte 0000 0000 0000 0000 FFF0 7FFF cela soit automatique ? Merci d'avance à ceux qui se pencheront sur mon cas. Caroual Excel - French Discussions WorksheetFunction (1) AddIns (1) Worksheets (1) Excel 2007 (1) Macro (1) Proc (1) LEFT (1) VBA (1) Bonsoir Dans la doc sur 426a74cc@news.free.fr. . . Bonjour, J'ai un probl?me de recalcul de ma feuille excel. J'importe une colonne qui se retrouve en texte 0000 0000 0000 0000 FFF0 7FFF e ou Bonjour, D??butons par une petite explication : Auparavant sous les versions ant??rieures ?? Excel 2007, si les 2 macros compl??mentaires ("utilitaire d'analyse" ou titre d'exemple directement est diff??rente, certains pourraient bien ??prouver des difficult??s. Tous (ou presque) savent qu'Excel sous les versions pr??c??dentes ?? Excel 2007, ne fait pas la traduction des fonctions d'une langue ?? l'autre lorsqu'elles

Excel and the Math Coprocessor for DLLs Excel I have a large Win32 DLL (10 MB) that is called from my user interface (written in C++) or from VBA in MS Excel. In my user interface, the DLL runs in its own space and calculates correctly. Under Excel VBA, my DLL is having problems with double precision accuracy. The following test passes in bottom CHPTST = (DIVTWO * bottom) - top In my user interface, the chptst result is zero. Under Excel VBA, the chptst result is 0.2851266E-09. I have tried resetting the math coprocessor _status87 (); if (old87Status ! = 0) new87result = _control87 (new87ControlWord, new87ControlMask); I have verified this behavior in both Excel 2003 and 2010. Does anyone have any ideas here ? Sincerely, Lynn McGuire Excel Discussions Windows XP (1) Visual Studio 2005 (1) Microsoft Excel (1) Visual Studio (1) Excel 2010 (1) Excel 2003 (1) Excel 2007 (1) Workbooks (1

Contatore Excel Ciao, sto cercando di fare in modo che all'apertura di un file venga scritta che contenga le date di apertura. Qualcuno ha uno script gi = E0 fatto? tks Sandro Excel - Italian Discussions ThisWorkbook.Worksheets Foglio1 With sh (1) Nothing End Sub Modifica Foglio1 (1) Worksheets (1) Excel 2010 (1) Excel 2007 (1) Macro (1) Date (1) VBA (1) = 3D = 3D = 3D = 3D = 3D = 3D = 3D le cose *fatte bene*. Questo nel modulo di codice di ThisWorkbook (o Questa_Cartella_Di_Lavoro se utilizzi Excel 2010): Private Sub Workbook_Open() Dim sh As Worksheet Set sh = ThisWorkbook.Worksheets("Foglio1") With sh il nome del foglio, no? Altrimenti, 'ndo cojo cojo(che i romani mi scusino). Ed Excel 2007 e 2010 hanno oltre un milione di righe, non 65536. - -- -- -- -- -- -- -- -- -- -- -- -- -- Mauro Gamberini Microsoft MVP - Excel http: / / www.riolab.org / http: / / www.maurogsc.eu / On 21 Dic, 14:13, "Mauro Gamberini le cose *fatte bene*. Questo nel modulo di codice di ThisWorkbook (o Questa_Cartella_Di_Lavoro se utilizzi Excel 2010): Private Sub Workbook_Open() Dim sh As Worksheet Set sh = 3D ThisWorkbook.Worksheets("Foglio1") With

how to find union of two arrays Excel Hello, Does anyone know a means of comparing two very large arrays (> 50000 elements) to to both arrays? I have tried using looping functions and that is far too slow. Excel Programming Discussions GetCurrentProcessId (1) Worksheets (1) Excel 2003 (1) Excel 2007 (1) Workbooks (1) Excel (1) Statistics (1) Relative (1) hi, i do not know why your looping is far the CPU is faster. There are other programming constructs available which are faster. I know Excel can run faster than this, but I do not know any tricks on how to 34, Andrew a ?crit : Why use code at all? You can do this with straight Excel formulas. Assuming your range "A" is located on Sheet1, Columns A and B, starting in 1:A$500, A1), MATCH(A1, Sheet1!A$1:A$500, 0), "") Rick Rothstein (MVP - Excel) If you do not want to do it with worksheet formulas, as suggested by Rick