Excel Left/Right function

  • Thread starter Thread starter ejay
  • Start date Start date
E

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.
 
MID
=MID(A1,startnum,numcharacters)
So, if you want the 15th character and 15th character only...
=MID(A1,15,1)

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

Peter
 
Back
Top