Excel Formula for units,Tens and others

[Chandresh]

Hi Team ,

Need a help in formula , I have used macro to convert the numbers to words(Column -H) and its working fine.

I need a help in splitting the numbers in 1) UNIT, 2) TENS, 3) HUNDRED, 4) THOUSANDS, 5) LAKHS, 6) CRORES.

Below is the output for your reference.

Cloumn -A	Cloumn -B	Cloumn -C	Cloumn -D	Cloumn -E	Cloumn -F	Cloumn -G	Cloumn -H
Amount	CRORES	LACS	THOUSAND	HUNDRED	TENS	UNIT	IN WORD
3,72,874.00​		3	72​	8​	7​	4​	Rupees Three Lakh SeventyTwo Thousand Eight Hundred SeventyFour Only
1,50,25,678.00	1​	50​	25​	6​	7​	8​	Rupees One Crore Fifty Lakh TwentyFive Thousand Six Hundred SeventyEight Only

Thanks in advance for your help

Chan