Excel Left/Right function
 

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.

Excel Left/Right function
 

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.

Excel Left/Right function
 

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.

Excel Left/Right function
 

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

Peter

"Otto Moehrbach" wrote in message
...
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.