| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.newusers
|
|||
|
|||
|
distributing each characters on a cell
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 |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.newusers
|
|||
|
|||
|
distributing each characters on a cell
thanks a lot!!!!
"NickHK" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming,microsoft.public.excel.newusers
|
|||
|
|||
|
distributing each characters on a cell
I'm sure spotted/fixed it, but it should be :
B1=MID($A1,COLUMN()-1,1) NickHK "jjuan" wrote in message ... thanks a lot!!!! "NickHK" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming,microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming,microsoft.public.excel.newusers
|
|||
|
|||
|
distributing each characters on a cell
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Number of characters in a cell (one row, merged columns) | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| if cell starts with characters formula | Excel Discussion (Misc queries) | |||
Linear Mode
