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