MID
=MID(A1,startnum,numcharacters)
So, if you want the 15th character and 15th character only...
=MID(A1,15,1)

Hope this helps.
--
John C


"ejay" wrote:

The above function will not pull "each single character" from a string.
I have text strings up to 27 characters.
I want to pull "each character" into a separate column.

Is there a function to do this without a macro?

My purpose is to delete some characters and use
Data Filter on each remaining character.