distributing each characters on a cell

[jjuan]

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

 

[Niek Otten]

In B1:

=MID($A$1,COLUMN(A1),1)

Copy to C1:E1

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
|
|
|

 

[Dave Peterson]

And if you have lots to do in that column, you can select that column
data|text to columns
Fixed width
draw a line between each character
and tell it to put the results in B1