VALUE function

Category:Text Name in English:VALUE That makes? Converts a text (representing a number) to a number. Syntax VALUE (text) text (required ): The text to be converted. Examples VALUE (“1.1525”) = …

Read moreVALUE function

VALUE.NUMBER function

Category:Text What does the VALUE.NUMBER function do? The VALUE.NUMBER function converts text to number independently of locale. Availability Excel for Office 365: Yes Excel 2016: Yes Excel 2013: Yes Excel …

Read moreVALUE.NUMBER function

SERVICIOWEB function

Category:Web What does the SERVICEOWEB function do? The SERVICEOWEB function returns data from a web service. Availability Excel 365: Yes Excel 2019: Yes Excel 2016: Yes Excel 2013: Yes Excel …

Read moreSERVICIOWEB function

URLCODIF function

Category:Web What does the URLCODIF function do? The URLCODIF function returns a URL-encoded string. AVAILABILITY Excel 365: Yes Excel 2019: Yes Excel 2016: Yes Excel 2013: Yes Excel 2010: No …

Read moreURLCODIF function

XMLFILTRO function

Category:Web What does the XMLFILTRO function do? The XMLFILTRO function returns data specific to the XML content using the specified XPath expression. Availability Excel 365: Yes Excel 2019: Yes Excel …

Read moreXMLFILTRO function

EXTRAE function

Category:Text Name in English:MID That makes? Extract a certain number of characters from a text string. Syntax EXTRAE (text, start_position, num_chars) text (mandatory ): Text string containing the characters to …

Read moreEXTRAE function

TEXT function

Category:Text Name in English:TEXT That makes? Converts a numeric value to a text value by specifying a format. Syntax TEXT (value, format) value (required ): The numeric value to convert …

Read moreTEXT function

FIND function

Category:Text Name in English:SEARCH That makes? Returns the position within a text string where it finds a specified character. Syntax FIND (search_text, within_text, [start_num]) search_text (required ): The text to …

Read moreFIND function

TEXTOBAHT function

Category:Text Name in English:BAHTTEXT That makes? Converts a number into text Baht (Baht is the currency of Thailand). Syntax TEXTBAHT (number) number (required ): The number to be converted to …

Read moreTEXTOBAHT function

EQUAL function

Category:Text Name in English:EXACT That makes? Compare two text strings and tell us if they are the same. It is case-sensitive. Syntax EQUAL (text1, text2) text1 (required ): The first …

Read moreEQUAL function