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


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

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