Skip to main content

Hey,



I have a column containing words from a enumeration:



ONE


TWO


THREE


FOUR


FIVE


Does any one know of a formula to automatically replace those words by their corresponding number?



1


2


3


4


5


Any help appreciated 🙂

Hi,



SUBSTITUTE(


SUBSTITUTE(


SUBSTITUTE(


SUBSTITUTE(


SUBSTITUTE(


{Field name},


'ONE','1'),


'TWO','2'),


'THREE','3'),


'FOUR','4'),


'FIVE','5')

Reply


Terms & Conditions