Have a look at LEFT, MID, & RIGHT functions which you can use in formulas or
macros to do this. something like this.
for each c in selection
c.offset(0,1)=left(c,2)
c.offset(0,2)=mid(c,3,3)
'etc
next
--
Don Guillett
SalesAid Software
"Jack Edwards" <Jack wrote in message
...
In Excel, how do I break up text in 1 cell and put the parts in other
cells?
Say I have the text ABCDEF in one cell and I want AB in a cell, C in other
cell, and DEF in a third cell. Is there a function or other way to do
this?