Converting a text string in a columb into numbers

[demyrhau]

I whish to convert a column of text into numbers. The text in the column is either <Active>, <Completed> or <Cannceled>. I want <Active> to have the value 1, <Completed> to have the value 2 and so on.

In advance, thank you! 

[Anonymous · Accepted solution]

StatusCode =
SWITCH ( Test[Status],

                       "Active", 1,

                      "Canceled", 2,

                      "Completed", 3

               )