Use Val Function To Convert Text Values. When we type in VALUE the tooltip clearly tells us what the function does. Converts a text string that represents a number to a number The syntax is as simple as it gets.
The only argument necessary is the text that needs to be converted. Choose Text to open the function drop-down list. Text return the combined text contents of all matched elements such as p div and so on val is used to obtain the value of an input element such as input select and so on according to the official documentation text should not be used.
In the dialog box select the Text line.
In the dialog box select the Text line. And I even checked the web for the right syntax. Select VALUE in the list to bring up the functions dialog box. The easiest way to convert a range of values to text though involves using the Text to Columns feature.