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
|