View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.newusers
gls858 gls858 is offline
external usenet poster
 
Posts: 209
Default distributing each characters on a cell

jjuan wrote:
how can i distribute the letter in a cell to another cells?
example:

A1=HELP

then get each character

B1=H
C1=E
D1=L
E1=P


I see you have an answer but here's another method.
Just click Data then text to columns. Select fixed
width set your breaks and click Finish

gls858