| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
split cell in number-cell and letter-cell
Hi Expert,
I would like a loop-routine to split out (letter and number) cells in a letter and a number cell, like: (It has to be implemented by a vba routine, no worksheet formula) The first part are always letters, the last part numbers. input: output after routine: cellColumnA: cellColumnB: cellColumnC: peterpan 89772 peterpan 89772 Please, could someone help me out? best regards, Peter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split a number in a cell into parts | Excel Discussion (Misc queries) | |||
| HOW DO I ADD A LETTER BEFORE AN EXISTING NUMBER IN A CELL? | Excel Worksheet Functions | |||
| how to add a letter in front of each number in a cell | Excel Discussion (Misc queries) | |||
| How do I add row total when cell contains both number and letter . | Excel Discussion (Misc queries) | |||
| How do I get a letter in one cell ito equal a number in anotherl.. | Excel Discussion (Misc queries) | |||
Threaded Mode
