Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A word in one cell to go into many cells
I want to type a word in one cell and have it spread out into multiple cells.
Exmaple: Type the word "Baby" in cell A:1. B:1 will then have "B", B:2 will have "a", B:3 will have "b", and B:4 will have "y". |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
A word in one cell to go into many cells
Right click sheet tabview codeinsert this.
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < Range("a1").Address Then Exit Sub For i = 1 To Len(Target) Target.Offset(, i) = Mid(Target, i, 1) Next End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "KatiJ" wrote in message ... I want to type a word in one cell and have it spread out into multiple cells. Exmaple: Type the word "Baby" in cell A:1. B:1 will then have "B", B:2 will have "a", B:3 will have "b", and B:4 will have "y". |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
A word in one cell to go into many cells
I will assume that you really wish the word to be spread out *across*
columns, in a single row. Word in A1, broken down into B1, C1, D1, E1, etc... =IF(LEN($A1)<COLUMNS($A:A),"",MID($A1,COLUMNS($A:A ),1)) Enter in B1, then copy across and down as needed. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "KatiJ" wrote in message ... I want to type a word in one cell and have it spread out into multiple cells. Exmaple: Type the word "Baby" in cell A:1. B:1 will then have "B", B:2 will have "a", B:3 will have "b", and B:4 will have "y". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make cell equal a word if a data validation cell has a word in it | Excel Discussion (Misc queries) | |||
How do I copy data in Excel cells and paste in Word w/o cell borde | Excel Discussion (Misc queries) | |||
Excel - allow cell margins similar to Word table cells | Excel Worksheet Functions | |||
Split Long Text Cell into Two Shorter Cells Without Splitting Word | Excel Discussion (Misc queries) | |||
Displaying cell references next to embedded cells in Word 2000 | New Users to Excel |