Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 07, 2022 11:52 PM
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 :slightly_smiling_face:
Sep 08, 2022 01:53 AM
Hi,
SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( {Field name}, 'ONE','1'), 'TWO','2'), 'THREE','3'), 'FOUR','4'), 'FIVE','5')