Posted to microsoft.public.excel.programming,microsoft.public.excel.newusers

external usenet poster

Posts: 18

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
convert 5 characters in a cell to 6 characters by adding a zero	Helenf	Excel Discussion (Misc queries)	4	May 18th 09 04:43 PM
distributing each characters on a cell	jjuan	New Users to Excel	5	October 25th 06 04:55 PM
Distributing a Cell Value	MLCole	Excel Worksheet Functions	5	March 7th 06 05:23 PM
Distributing a UDF	David	Excel Programming	3	November 30th 05 11:56 AM
Distributing an add in	Daniel McCollick	Excel Programming	3	June 8th 05 07:30 PM

All times are GMT +1. The time now is 11:39 AM.

About Us

"It's about Microsoft Excel"