A worksheet contains the numbers 1 to 5 in column A. Use the SUBSTITUTE function to change each number to a word. For example, change 1 to one, 2 to two, 3 to three, 4 to four, and 5 to five.
To convert each number to a word:
1. In column A, type a series of numbers using 1, 2, 3, 4, and 5.
2. Select cells B2:B10 and type the following formula: =(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE
(SUBSTITUTE(SUBSTITUTE(A2,1,"one-"),2,"two-"),3,"three-"),4,"four-"),5,"five-")).
3. Press <-Ctrl+Enter->.
Watch the Video Tutorial - https://www.youtube.com/watch?v=5BtcRlfBNIk
Hope You Enjoy This Tutorials - Give Comments
I wasn't aware of how to use SUBSTITUTE function to covert numbers to words. This method is very easy and helpful for conversions. The screenshot helped a lot in understanding the concept well. Thanks for sharing the idea with us.
ReplyDeleteeSignature
Very thanks
ReplyDelete