Thread: Is there such thing as deoncantenate in excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default 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
Reply With QuoteReply With Quote