View Single Post
  #2   Report Post  
Old July 28th 12, 09:07 AM posted to microsoft.public.excel.newusers
Claus Busch Claus Busch is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,787
Default Separation of text - concatenate excel

Hi,

Am Sat, 28 Jul 2012 00:02:05 -0700 (PDT) schrieb ExceLearner:

A Word in A1=Apple - I want to break it up in to
C1 - A
C2 - P
C3 - P


try in C1:
=MID($A$1,ROW(),1) and drag down


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2