How to extract each digit from a number in one cell?
Data TextToColumns Fixed and set a column for each digit in your
maximum length number...........
hth
Vaya con Dios,
Chuck, CABGx3
"greyhound girl" wrote:
I need to extract each digit from a number entered in one cell. I then need
to multiply each digit by another digit. The second part I can handle. It's
how to parse that number into it's separate digits that is the challenge. I
am used to redefine capabilities in other languages but can't find any easy
equivalend in Excel.
|