USE THE SUBSTITUTE FUNCTION TO CONVERT NUMBERS TO WORDS USING MICROSOFT EXCEL

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->.

USE THE SUBSTITUTE FUNCTION TO CONVERT NUMBERS TO WORDS USING MICROSOFT EXCEL