Thank you, I ended up using the Mid formula. I knew I had seen it somewhere in the formula listing before, but as you know, the older you get, the fewer powers of recall you have, it seems. Thank you so much for taking time to respond.
"Trevor Shuttleworth" wrote in message ...
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.