| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Return a digit in a string of numbers
Windows XP
Office XP I would like to know if there is a formula which will return a specified digit in a string of digits. For example, assuming I have a number 5891034 in cell A1, then I want to place a formulas into cell A2-A8 that will separate each digit from that number into cells so that cell A2 would return the first digit "5", cell A3 returns the second digit "8", cell A4 returns the third digit "9", cell A5 returns the fourth digit "1", etc. Is this possible? Thanks in advance for any help you can provide. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
| How do you display 16 digit numbers in excel ? (it keeps convert. | Excel Discussion (Misc queries) | |||
| I wish to change the last digit in a list of random numbers. To a. | Excel Worksheet Functions | |||
| 16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
| How do you extract numbers from a string of chacters in a cell (E. | Excel Worksheet Functions | |||
Threaded Mode
