5th Char in a cell

  • Thread starter Thread starter enna49
  • Start date Start date
E

enna49

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
 
Thank you, Thank you.
Sometimes we try to make things more difficult that what they are.
Anne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to count if cell "contains" a word 22
Averaging every 5th cell while omitting zeros 4
Extracting Data from a string of text in a cell 4
Desire Weekday returned in every 5th Cell 1
How to reference Cells AA and forward with CHAR (and a bonus quest 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Deleting LF Characters in cells 9
Match Email address to Filenames in a list and Send Email As Attachment 2

Back
Top