Is there such thing as deoncantenate in excel?
 

I am trying to seperate out the characters within one cell into individual
cells, is there a way of doing this?

Is there such thing as deoncantenate in excel?
 

On Fri, 27 Nov 2009 14:48:01 -0800, Jonny 9 <Jonny
wrote:

I am trying to seperate out the characters within one cell into individual
cells, is there a way of doing this?

With your string of characters in A1,

B1: =MID($A1,COLUMNS($A:A),1)

and fill right as far as required.

Or:

A2: =MID(A$1,ROWS($1:1),1)

and fill down as far as required.
--ron