Excel Left/Right function

[ejay]

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.

 

[John C]

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

Hope this helps.

 

[Otto Moehrbach]

Try Data - Text to columns, fixed width of one character. HTH Otto

 

[Peter]

You learn something new everyday, Text to Columns i'll have to remember that
one, i wonder how Ejay got on...

Peter