# Convert a numeric value into words in Excel

the number to Convert from text form into normal number of digits: for example, "one hundred and fifty-three" converted to 153.

Solve the problem for numbers from 1 to 999 999.

note: the Inverse problem - conversion of a regular number in the number of words solved in the article the Number of words in MS EXCEL (static version).

To solve the problem using the following algorithm:

• number of words remove the extra spaces using the function TRIM(),
•  number of words remove the declination at birth, for example "one thousand" is converted to "one thousand". This will greatly simplify the formulas. For this use the function SUBSTITUTE(),
• define the position of the word "thousand","thousand","thousand" function SEARCH(),
• to the left of the word "thousand" is the number of words to thousands, and the right number of units. Use function LEFT() and RIGHT() to extract these numbers,
• text values from 1 to 999 enter a single range, compare them to the number,
• using the function VLOOKUP() will extract the number in digital format by specifying the number of words.

note: Formulas can be found in example file below.