I have an API connected to my Sheets where I receive data in words instead of numbers. Example, Ratings data is recieved as "Five" instead of numeric "5". How do I convert the recieved data into numeric values? I have tried =value() and it doesn't seem to be working.

CodePudding user response：

Using

2- You can also use a standalone formula (following Gangula's idea)

=MATCH(A1,{"zero"; "one"; "two"; "three"; "four"; "five";"six"; "seven"; "eight"; "nine"},0)-1