Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split 5 digit number into 5 cells
Hi everyone
I am sure I have seen this before but it is not showing up on Google. A1 has a 5 digit number eg 12345 I want a formula or VBA code to produce A2=1 A3=2 A4=3 A5=4 A6=5 anyone point me in the right direction? Kenny Win XP Office 2003 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to split a 17 digit number into 17 cells by paste function. | Excel Discussion (Misc queries) | |||
How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) |