You could just use Data | text to columns ... | Fixed length (1 character)

Alternatively you could use MID to extract characters

=MID(A1,1,1), =MID(A1,2,1), etc

Regards

Trevor


"W M" wrote in message ...
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.