View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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.