How to convert digits to word in Excel


I am trying to convert digits like “456” into four fifty six. so can anyone help me this regard.


You’ll need to create a loop using logic such as this :slight_smile:

Effectively split the “456” string into characters then for each character determine what the equivalent word is. There may be an easier way than this- doesn’t seem particularly efficient.