Try Data - Text to columns, fixed width of one character. HTH Otto
"ejay" wrote in message
...
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.