Pages

Tuesday, April 12, 2011

Use the SUBSTITUTE function to convert numbers to words - Text Functions - Microsoft Excel Tutorials


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

2 comments:

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

    ReplyDelete

Submit Site to Google Free Articles Search Engine Submission - AddMe Directories Suggest Link Business Directory AutoBackLinks Directory Bingo Bahia Submission Software Reviews