distributing each characters on a cell

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


0
10/25/2006 6:35:20 AM
excel.newusers 15348 articles. 2 followers. Follow

5 Replies
391 Views

Similar Articles

[PageSpeed] 32

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

NickHK

"jjuan" <jp4the_clan@yahoo.com> wrote in message
news:eSXqv%23$9GHA.1220@TK2MSFTNGP05.phx.gbl...
> 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
>
>


0
TungCheWah (25)
10/25/2006 6:39:33 AM
thanks a lot!!!!

"NickHK" <TungCheWah@Invalid.com> wrote in message 
news:u4GAgBA%23GHA.5092@TK2MSFTNGP04.phx.gbl...
> Here's one way :
> B1=MID($A25,COLUMN()-1,1)
> and copy across.
>
> NickHK
>
> "jjuan" <jp4the_clan@yahoo.com> wrote in message
> news:eSXqv%23$9GHA.1220@TK2MSFTNGP05.phx.gbl...
>> 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
>>
>>
>
> 


0
10/25/2006 7:11:00 AM
I'm sure spotted/fixed it, but it should be :
B1=MID($A1,COLUMN()-1,1)

NickHK

"jjuan" <jp4the_clan@yahoo.com> wrote in message
news:%23lCyrSA%23GHA.4404@TK2MSFTNGP04.phx.gbl...
> thanks a lot!!!!
>
> "NickHK" <TungCheWah@Invalid.com> wrote in message
> news:u4GAgBA%23GHA.5092@TK2MSFTNGP04.phx.gbl...
> > Here's one way :
> > B1=MID($A25,COLUMN()-1,1)
> > and copy across.
> >
> > NickHK
> >
> > "jjuan" <jp4the_clan@yahoo.com> wrote in message
> > news:eSXqv%23$9GHA.1220@TK2MSFTNGP05.phx.gbl...
> >> 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
> >>
> >>
> >
> >
>
>


0
TungCheWah (25)
10/25/2006 7:14:35 AM
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
0
gls858 (460)
10/25/2006 2:56:13 PM
See your other thread, too.

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

-- 

Dave Peterson
0
petersod (12005)
10/25/2006 3:55:20 PM
Reply:

Similar Artilces: