For Example: 2 - Two |
22 - Two Two |
58 - Five Eight |
79 - Seven Nine |
96 - Nine Six |
Formula:
=IF(LEN(A1)=1,VLOOKUP(A1,{0," Zero";1,"One";2,"Two";3," Three";4,"Four";5,"Five";6," Six";7,"Seven";8,"Eight";9," Nine"},2,FALSE),VLOOKUP(VALUE( LEFT(A1,1)),{0,"Zero";1,"One"; 2,"Two";3,"Three";4,"Four";5," Five";6,"Six";7,"Seven";8," Eight";9,"Nine"},2,FALSE)& VLOOKUP(VALUE(RIGHT(A1,1)),{0, "Zero";1,"One";2,"Two";3," Three";4,"Four";5,"Five";6," Six";7,"Seven";8,"Eight";9," Nine"},2,FALSE))
No comments:
Post a Comment