Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breaking a word by each alphabet and inputing it in different cells
Hi,
We have a form in Excel (something like a bank form) where the details have to be filled in by each character in each cell. for eg. the word PEPSI would be required to be typed by each alphabet in the 5 adjoining cells. Can someone help me out with a macro such that I type the word(could be 5 to 20 characters long) in the first cell and run the macro. It should automatically separate the characters in the adjoining cells. Another way would be to place the cursor (active cell) on the first cell and run the macro which would display an input box. On entering the words in the input box and pressing enter, all the characters would be displayed in separate cells starting from the first cell. Thanks Sandip. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breaking a word by each alphabet and inputing it in different cells
Sandip
This should get you started. Tony Sub aaa() GetWord = InputBox("get word") Range("a5").Select For i = 1 To Len(GetWord) ActiveCell.Offset(0, i - 1).Value = Mid(GetWord, i, 1) Next i End Sub -----Original Message----- Hi, We have a form in Excel (something like a bank form) where the details have to be filled in by each character in each cell. for eg. the word PEPSI would be required to be typed by each alphabet in the 5 adjoining cells. Can someone help me out with a macro such that I type the word(could be 5 to 20 characters long) in the first cell and run the macro. It should automatically separate the characters in the adjoining cells. Another way would be to place the cursor (active cell) on the first cell and run the macro which would display an input box. On entering the words in the input box and pressing enter, all the characters would be displayed in separate cells starting from the first cell. Thanks Sandip. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
modify linked cells without breaking link | Excel Discussion (Misc queries) | |||
How to add cells yet neglecting alphabet dats | Excel Discussion (Misc queries) | |||
Split cell without breaking word? | Excel Discussion (Misc queries) | |||
breaking text in one cell into two cells | Excel Discussion (Misc queries) | |||
Adding cells with alphabet and returning a numbric value | Excel Worksheet Functions |