Skip to main content

Automatically replace specific words with a number in a column

  • September 8, 2022
  • 1 reply
  • 13 views
A

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:

1 reply

Alexey_Gusev
Forum|alt.badge.img+25
  • Alexey_Gusev
  • Brainy
  • September 8, 2022

Hi,

SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
{Field name},
'ONE','1'),
'TWO','2'),
'THREE','3'),
'FOUR','4'),
'FIVE','5')
Terms & ConditionsAccessibility statement