Here's one way :
B1=MID($A25,COLUMN()-1,1)
and copy across.

NickHK

"jjuan" wrote in message
...
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