Excel 2007 fonctions French-English

>> From English to French

You can use the search function (CTRL + F) to find a Specific function.

Function Function Description
Complement and automation Add-in and Automation functions
FONCTION.APPELANTE CALL Calls a procedure in the dynamic link library or code resource.
EUROCONVERT EUROCONVERT Converts a number to euros, converts a number into a euro currency in the European area or converts a number from one currency in the European zone into another, using the euro as an intermediary (triangulation).
GETPIVOTDATA GETPIVOTDATA Returns data stored in a PivotTable report.
REGISTRE.NUMERO REGISTER.ID Returns the registry identification number of the dynamic link library that was specified or code resource that has been put into the register above.
SQL.REQUEST SQL.REQUEST Connects to an external data source, runs a query from a worksheet, then returns the result as a matrix, without the need to program a macro.
Cube Functions Cube functions  
MEMBREKPICUBE CUBEKPIMEMBER Returns a name, a property and a measure KPI and displays the name and property in the cell. A KPI is a quantifiable measure, such as profit margin or gross monthly quarterly turnover, used to evaluate the performance of a company.
MEMBRECUBE CUBEMEMBER Returns a member or tuple in a cube hierarchy. Use this function to validate the existence of the member or tuple in the cube.
PROPRIETEMEMBRECUBE CUBEMEMBERPROPERTY Returns the value of a member property of the cube. Use this function to validate the existence of a member name in the cube and to return the specified property for this member.
CUBERANKEDMEMBER CUBERANKEDMEMBER Returns the nth member or member placed at a certain rank in a set. Use to return one or more elements of a set, such as best sellers or top 10 students.
JEUCUBE CUBESET Defines a set of calculated members or tuples by sending a term defined in the cube on the server that creates all and returns it to Microsoft Office Excel.
NBJEUCUBE CUBESETCOUNT Returns the number of elements in a game.
VALEURCUBE CUBEVALUE Returns a result aggregate value of a cube.
Database functions Database functions
DAVERAGE DAVERAGE Returns the average of selected database entries.
BCOMPTE DCOUNT Counts the number of cells in a database that contain numbers.
DCOUNTA Dcounta In non-empty cells in a database.
DGET DGET Extract from a database a single record that meets the specified criteria.
DMAX DMAX Returns the maximum value of the selected database entries.
DMIN DMIN Returns the minimum value of the selected database entries.
DPRODUCT DPRODUCT Multiplies the values ​​of a particular field of records in a database that meet specified criteria.
DSTDEV DSTDEV Calculates the standard deviation for a sample of basic inputs selected data.
DSTDEVP DSTDEVP Calculates the standard deviation for the entire population of selected database entries.
DSUM DSUM Adds the numbers in the record field column of the database that meet the criteria.
DVAR SSDs Calculates the variance for a sample of database entries of selected data.
DVARP DVARP Calculates the variance for the entire population of selected database entries.
Date and Time Functions Date and time functions
DATE DATE Returns the serial number of a specific date.
DATEVALUE DATEVALUE Converts a date represented in text form serial number.
DAY DAY Converts a serial number of the month.
DAYS360 DAYS360 Calculates the number of days between two dates based on a year of 360 days.
EDATE EDATE Returns the serial number of the date that represents a specified date (the argument start_date) corrected or down the specified number of months.
EOMONTH EOMONTH Returns the sequential number of the last day of the month before or after start_date the specified number of months.
TIME HOUR Converts a serial number to an hour.
MINUTE MINUTE Converts a serial number to a minute.
MONTH MONTH Converts a serial number to a month.
NETWORKDAYS NETWORKDAYS Returns the number of whole working days between two dates.
RIGHT NOW NOW Returns the serial number of the date and time of day.
SECOND SECOND Converts a serial number to a second.
TIME TIME Returns the serial number of a particular time.
TIMEVALUE TIMEVALUE Converts a date represented in text form serial number.
TODAY TODAY Returns the serial number of the current date.
WEEKDAY WEEKDAY Converts a serial number to a day of the week.
WEEKNUM WEEKNUM Converts a serial number to a number representing the order of the week in the year.
Workdays WORKDAY Returns the serial number of the date before or after the specified number of days worked.
YEAR YEAR Converts a serial number to a year.
YEARFRAC YEARFRAC Returns the portion of the year is the number of days between the start date and end date.
Engineering Functions Engineering functions
BESSELI BESSELI Returns the modified Bessel function In (x).
BESSELJ BESSELJ Returns the Bessel function Jn (x).
BESSELK BESSELK Returns the modified Bessel function Kn (x).
BESSELY BESSELY Returns the Bessel function Yn (x).
Bindec BIN2DEC Converts a binary number to decimal.
BINHEX BIN2HEX Converts a binary number to hexadecimal number.
BINOCT BIN2OCT Converts a binary number to octal.
SELF CONSCIOUS COMPLEX Converts real and imaginary coefficients into a complex number.
CONVERT CONVERT Converts a number of a unit of measurement to another.
Decbin DEC2BIN Converts a decimal to binary number.
Dechex DEC2HEX Converts a decimal to hexadecimal number.
Decoct DEC2OCT Converts a decimal to octal number.
DELTA DELTA Tests the equality of two numbers.
ERF ERF Returns the value of the error function.
ERFC ERFC Returns the value of the complementary error function.
GESTEP GESTEP Testing if a number is greater than a threshold value.
Hexbin HEX2BIN Converts a hexadecimal number to binary number.
Hexdec HEX2DEC Converts a hexadecimal number to decimal.
HEXOCT HEX2OCT Converts a hexadecimal number to octal.
IMABS IMABS Returns the absolute value (modulus) of a complex number.
IMAGINARY IMAGINARY Returns the imaginary coefficient of a complex number.
IMARGUMENT IMARGUMENT  Returns the argument theta, an angle expressed in radians.
IMCONJUGATE IMCONJUGATE Returns the complex conjugate of a complex number.
IMCOS IMCOS Returns the cosine of a complex number.
COMPLEXE.DIV IMDIV Returns the quotient of two complex numbers.
IMEXP IMEXP Returns the exponential function of a complex number.
IMLN IMLN Returns the natural logarithm of a complex number.
COMPLEXE.LOG10 IMLOG10 Calculates the base-10 logarithm of a complex number.
IMLOG2 IMLOG2 Calculates the base-2 logarithm of a complex number.
IMPOWER IMPOWER Returns a complex number raised to an integer power.
IMPRODUCT IMPRODUCT Returns the product of several complex numbers.
IMREAL IMREAL Returns the real coefficient of a complex number.
IMSIN IMSIN Returns the sine of a complex number.
IMSQRT IMSQRT Returns the square root of a complex number.
COMPLEXE.DIFFERENCE IMSUB Returns the difference between two complex numbers.
IMSUM IMSUM Returns the sum of several complex numbers.
OCTBIN OCT2BIN Converts an octal number to binary number.
Octdec OCT2DEC Converts an octal number to decimal.
OCTHEX OCT2HEX Converts an octal number to hexadecimal number.
Financial Functions Financial functions
ACCRINT ACCRINT Returns the accrued interest for a security that pays periodic interest.
ACCRINTM ACCRINTM Returns the accrued interest for a security that pays interest at maturity.
AMORDEGRC AMORDEGRC Returns the depreciation for each accounting period using a damping coefficient.
AMORLINC AMORLINC Returns the depreciation of an asset at the end of a given tax period.
COUPDAYBS COUPDAYBS Returns the number of days from the beginning of the coupon period to the date of liquidation.
COUPDAYS COUPDAYS Returns the number of days in the coupon period that contains the settlement date.
COUPDAYSNC COUPDAYSNC Returns the number of days between the settlement date and the date of the next coupon date of liquidation.
COUPNCD. COUPNCD Returns the first coupon date after the settlement date.
COUPNUM COUPNUM Returns the number of coupons payable between the settlement date and the maturity date.
COUPPCD COUPPCD Returns the coupon date preceding the settlement date.
CUMIPMT CUMIPMT Returns the cumulative interest paid on a loan between two periods.
CUMPRINC CUMPRINC Returns the cumulative capital repayments of a loan made between two periods.
DB DB Returns the depreciation of an asset for a specified period using the declining balance method at fixed rates.
DDB DDB Returns the depreciation of an asset for a specified period, using the declining balance method at double or as a coefficient to be specified.
TAUX.ESCOMPTE DISC Calculates the discount rate of a transaction.
DOLLARDE DOLLARDE Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.
DOLLARFR DOLLARFR Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction.
DURATION DURATION Returns the time, in years, of a security that pays periodic interest.
EFFECT EFFECT Returns the annual effective interest rate.
VC FV Returns the future value of an investment.
FVSCHEDULE FVSCHEDULE Calculates the future value of an investment by applying a series of compound interest rates.
INTRATE INTRATE Displays the interest rate of a fully invested security.
IPMT IPMT Calculates the amount of interest on an investment for a given period.
TRI IRR Calculates the internal rate of return of an investment in a succession of treasuries.
ISPMT ISPMT Calculates the amount of interest on an investment for a given period.
DUREE.MODIFIEE MDURATION Returns the Macauley modified duration for a security with an assumed par value of 100_euros.
TRIM MIRR Calculates the internal rate of return where positive and negative payments are financed at different rates.
NOMINAL NOMINAL Calculates the annual nominal interest rate.
NPM RPS Returns the number of necessary payments to repay a loan.
VAN NPV Calculates the net present value of an investment based on a series of disbursements and a discount rate.
ODDFPRICE ODDFPRICE Returns the price per $ 100 face value of a euro as the first coupon period is irregular.
ODDFYIELD ODDFYIELD Returns the yield of a security that the first coupon period is irregular.
ODDLPRICE ODDLPRICE Returns the price per $ 100 face value of a euro as the first coupon period is irregular.
ODDLYIELD ODDLYIELD Returns the yield of a security with the last coupon period is irregular.
VPM PMT Calculates the periodic payment of a given investment.
PPMT PLMP Calculated for a given period, the share of repayment of the principal of an investment.
PRIX.TITRE PRICE Returns the price of a security that pays periodic interest, for a nominal value of 100 euros.
PRICEDISC PRICEDISC Returns the value of a collection commercial discount, for a nominal value of 100 euros.
PRICEMAT PRICEMAT Returns the price of a security whose nominal value is EUR 100 and that pays interest at maturity.
VA PV Calculates the present value of an investment.
RATE RATE Calculates the interest rate per period for an annuity.
VALEUR.NOMINALE RECEIVED Returns the nominal value at maturity of a negotiable instrument.
SLN SLN Calculates the linear depreciation of an asset for a specified period.
SYD SYD Calculates the depreciation of an asset for a given period on the basis of the sum-of-years' digits (declining balance rate applied descending at a constant value).
TAUX.ESCOMPTE.R TBILLEQ Returns the rational discount rate of a Treasury bill.
TBILLPRICE TBILLPRICE Returns the price of a Treasury bond with a face value of 100 euros.
RENDEMENT.BON.TRESOR TBILLYIELD Calculates the yield of a Treasury bill.
VDB VDB Returns the depreciation of an asset for a specified or partial period using a declining balance method at fixed rates.
XIRR XIRR Calculates the internal rate of return of a set of non-periodic payments.
XNPV XNPV Returns the net present value of a set of non-periodic payments.
YIELD YIELD Calculates the yield of a security that pays interest periodically.
RENDEMENT.SIMPLE YIELDDISC Calculates the rate of return on a loan simple interest (for example, a Treasury bill).
RENDEMENT.TITRE.ECHEANCE YIELDMAT Returns the annual yield of a security that pays interest at maturity.
Information Functions Information functions
CELL CELL Returns information on the layout, the location and contents of a cell.
ERROR.TYPE ERROR.TYPE Returns a number corresponding to an error type.
INFORMATION INFO Returns information about the current operating environment.
ISBLANK ISBLANK Returns TRUE if value is empty.
ISERR ISERR Returns TRUE if value refers to any error value except # N / A.
ISERROR ISERROR Returns TRUE if value refers to an error value.
ISEVEN ISEVEN Returns TRUE if the number is even.
ISLOGICAL ISLOGICAL Returns TRUE if value refers to a logical value.
ISNA ISNA Returns TRUE if value refers to the error value # N / A.
ISNONTEXT ISNONTEXT Returns TRUE if value is not in the form of text.
ISNUMBER ISNUMBER Returns TRUE if value is a number.
ISODD ISODD Returns TRUE if the number is odd.
ISREF ISREF Returns TRUE if value is a reference.
ISTEXT ISTEXT Returns TRUE if value is in the form of text.
N N Returns a value converted to a number.
N / A N / A Returns the error value # N / A.
TYPE TYPE Returns a number indicating the data type of a value.
Logical Functions Logical functions
AND AND Returns TRUE if all its arguments are TRUE.
FALSE FALSE Returns the logical value FALSE.
SI IF Specifies a logical test to perform.
IFERROR IFERROR Returns a value that you specify if a formula generates an error; otherwise it returns the result of the formula.
I DONT NO NOT  Reverses the logic of this argument.
OR OR Returns TRUE if any argument is TRUE.
TRUE TRUE Returns the logical value TRUE.
Research and reference functions Lookup and reference functions
ADDRESS ADDRESS Returns a reference as text to a single cell of a spreadsheet.
ZONES AREAS Returns the number of areas in a reference.
CHOOSE CHOOSE Chooses a value from a list.
COLUMN COLUMN Returns a reference to the column number.
COLUMNS COLUMNS Returns the number of columns in a reference.
HLOOKUP HLOOKUP Performs a search in the first row of a matrix and returns the value of the indicated cell.
HYPERLINK HYPERLINK Creates a shortcut or reference that opens a document stored on a network server, an intranet or the Internet.
INDEX INDEX Uses an index to choose a value from a reference or a matrix.
INDIRECT INDIRECT Returns a reference indicated by a text value.
SOUGHT AFTER LOOKUP Mark values ​​in a vector or a matrix.
MATCH MATCH Search for values ​​in a reference or array.
OFFSET OFFSET Returns a reference offset relative to a given reference.
ONLINE ROW Returns a reference to the line number.
LINES ROWS Returns the number of rows in a reference.
RTD RTD Retrieves real-time data from a program that supports COM automation (Automation: Using objects in an application from another application or another development tool Formerly called OLE Automation. Automation is an industry standard and a feature of the COM object model (Component Object Model).).
TRANSPOSE TRANSPOSE Returns the transpose of a matrix.
VLOOKUP VLOOKUP Performs a search in the first column of a matrix and moves on the line to return the value of a cell.
Mathematical and trigonometric functions Math and trigonometry functions
ABS ABS Returns the absolute value of a number.
ACOS ACOS Returns the arc cosine of a number.
ACOSH ACOSH Returns the inverse hyperbolic cosine of a number.
ASIN ASIN Returns the arcsine of a number.
ASINH ASINH Returns the inverse hyperbolic sine of a number.
ATAN ATAN Returns the arctangent of a number.
ATAN2 ATAN2 Returns the arctangent of x and y coordinates.
ATANH ATANH Returns the inverse hyperbolic tangent of a number.
CEILING CEILING Rounds a number to the nearest whole number or the nearest multiple of precision argument away from zero.
COMBINED COMBINED Returns the number of combinations that can be formed with a given number of objects.
COS COS Returns the cosine of a number.
COSH COSH Returns the hyperbolic cosine of a number.
DEGREES DEGREES Converts radians to degrees.
PAIR EVEN Rounds a number to the nearest even integer away from zero.
EXP EXP Returns e raised to the power of a given number.
FACT FACT Returns the factorial of a number.
FACTDOUBLE FACTDOUBLE Returns the double factorial of a number.
FLOOR FLOOR Rounds a number down, toward zero (0).
GCD GCD Returns the greatest common divisor.
ENT INT Rounds a number down to the nearest integer.
LCM LCM Returns the least common multiple.
LN LN Returns the natural logarithm of a number.
LOG LOG Returns the logarithm of a number in the specified base.
LOG10 LOG10 Calculates the base-10 logarithm of a number.
MDETERM MDETERM Returns the determinant of a matrix.
MINVERSE MINVERSE Returns the inverse matrix of a matrix.
MMULT MMULT Returns the product of two matrices.
MOD MOD Returns the remainder of a division.
MROUND MROUND Give rounding a number to the specified multiple.
MULTINOMIAL MULTINOMIAL Calculates the multinomial of a set of numbers.
ODD ODD Returns the number rounded to the value of the nearest odd integer away from zero.
PI PI Returns the value of pi.
POWER POWER Returns the value of the number raised to a power.
PRODUCT PRODUCT Multiplies its arguments.
QUOTIENT QUOTIENT Returns the integer part of the result of a division.
RADIANS RADIANS Converts degrees to radians.
ALEA RAND Returns a random number between 0 and 1.
RANDBETWEEN RANDBETWEEN Returns a random number between the numbers you specify.
ROMAIN ROMAN Converts Arabic numerals Roman numerals as text.
ROUND ROUND Rounds a number to the specified number of digits.
ROUNDDOWN ROUNDDOWN Rounds a number down, toward zero (0).
ROUNDUP ROUNDUP Rounds a number to the next whole, away from zero.
SERIESSUM SERIESSUM Returns the sum of a geometric series based on the following formula:
SIGNS SIGN Returns the sign of a number.
SIN SIN Returns the sine of the given angle.
SINH SINH Returns the hyperbolic sine of a number.
RACINE SQRT Returns the square root of a number.
SQRTPI SQRTPI Returns the square root of (number * pi).
SUBTOTAL SUBTOTAL Returns a subtotal in a list or database.
SUM SUM Calculates the sum of its arguments.
SOMME.SI SUMIF Adds the cells specified if they meet a given criteria.
SOMME.SI.ENS SUMIFS Adds the cells in a range that meet multiple criteria.
SUMPRODUCT SUMPRODUCT Multiplies the corresponding values ​​specified matrices and calculates the sum of these products.
SUMSQ SUMSQ Returns the sum of the squares of the arguments.
SUMX2MY2 SUMX2MY2 Returns the sum of the difference of the squares of corresponding values ​​of two matrices.
SUMX2PY2 SUMX2PY2 Returns the sum of the sum of the squares of corresponding values ​​of two matrices.
SUMXMY2 SUMXMY2 Returns the sum of the squared differences between the corresponding values ​​of the two matrices.
TAN TAN Returns the tangent of a number.
TANH TANH Returns the hyperbolic tangent of a number.
TRUNC TRUNC Returns the integer part of a number.
Statistical Functions Statistical functions
AVEDEV AVEDEV Returns the average of the absolute deviations observed in the average of the data points.
AVERAGE AVERAGE Returns the average of its arguments.
AVERAGEA AVERAGEA Returns the average of its arguments, numbers, text and logical values.
MOYENNE.SI AVERAGEIF Returns the average (arithmetic mean) of all cells in a range that meet the given criteria.
MOYENNE.SI AVERAGEIFS Returns the average (arithmetic mean) of all cells that meet multiple criteria.
BETADIST BETADIST Returns the cumulative distribution function.
BETAINV BETAINV Returns the inverse of the cumulative distribution function for a specified beta distribution.
BINOMDIST BINOMDIST Returns the probability of a discrete random variable the binomial distribution.
CHIDIST CHIDIST Returns the one-tailed probability of the chi-square distribution.
CHIINV CHIINV Returns the inverse of the one-tailed probability of the chi-squared distribution.
CHITEST ChiTest Returns the test for independence.
CONFIDENCE CONFIDENCE Returns the confidence interval for a population mean.
CORREL CORREL Returns the correlation coefficient between two data sets.
NB COUNT Determines the numbers included in the list of arguments.
COUNTA COUNTA Determines the number of values ​​in the argument list.
COUNTBLANK COUNTBLANK Count the number of empty cells in a range.
NB.SI COUNTIF Counts the number of cells that meet a given criteria in a range.
COUNTIFS COUNTIFS Counts the number of cells within a range that meet multiple criteria.
COVARIANCE COVAR Returns covariance, mean deviation of products for each series of observations.
CRITBINOM CRITBINOM Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
DEVSQ DEVSQ Returns the sum of squared deviations.
EXPONDIST EXPONDIST Returns the exponential distribution.
FDIST FDIST Returns the probability distribution F.
FINV FINV Returns the inverse of the probability distribution F.
FISHER FISHER Returns the Fisher transformation.
FISHERINV FISHERINV Returns the inverse of the transformation of Fisher.
PREDICTION FORECAST Calculates a value from a linear trend.
FREQUENCY FREQUENCY Calculates the frequency of occurrence of values ​​in a range of values, and then returns the numbers as a vertical array.
FTEST FTest Returns the result of an F test
GAMMADIST GAMMADIST Returns the probability of a random variable following a gamma distribution.
GAMMAINV GAMMAINV Returns for a given probability, the value of a random variable following a gamma distribution.
GAMMALN GAMMALN Returns the natural logarithm of the Gamma function, G (x)
GEOMEAN GEOMEAN Returns the geometric mean.
GROWTH GROWTH Calculates values ​​relative to an exponential trend.
HARMEAN HARMEAN Returns the harmonic mean.
HYPGEOMDIST HYPGEOMDIST Returns the probability of a discrete random variable hypergeometric distribution.
INTERCEPT INTERCEPT Returns the y-intercept of a linear regression line.
KURT KURT Returns the kurtosis of a series of data.
LARGE LARGE Returns the k-th largest value in a data set.
LINEST LINEST Returns the parameters of a linear trend.
LOGEST LOGEST Returns the parameters of an exponential trend.
LOGINV LOGINV Returns the inverse of the probability that a random variable the lognormal distribution.
LOGNORMDIST LOGNORMDIST Returns the probability of a continuous random variable following a lognormal distribution.
MAX MAX Returns the maximum value in a list of arguments.
MAXA MAXA Returns the maximum value in a list of arguments, numbers, text and logical values.
MEDIAN MEDIAN Returns the median of the given numbers.
MIN MIN Returns the minimum value in a list of arguments.
MINA MINA Returns the smallest value in a list of arguments, numbers, text and logical values.
MODE MODE Returns the most common value in a data set.
NEGBINOMDIST NEGBINOMDIST Returns the probability of a discrete random variable following a negative binomial distribution.
NORMDIST NORMDIST Returns the probability of a continuous random variable following a normal distribution.
NORMINV NORMINV Returns for a given probability, the value of a random variable following a standard normal distribution.
NORMSDIST NORMSDIST Returns the probability of a continuous random variable following a standard normal distribution.
NORMSINV NORMSINV Returns the inverse of the standard normal cumulative distribution.
PEARSON PEARSON Returns the sample correlation coefficient of Pearson.
CENTILE PERCENTILE Returns the k-th percentile of values ​​in a range.
PERCENTRANK PERCENTRANK Returns the percentage rank of a value of a data series.
SWITCHING PERMUT Returns the number of permutations for a given number of objects.
POISSON FISH Returns the probability of a random variable following a Poisson distribution.
CHANCE PROB Returns the probability that the values ​​are a range between two limits.
QUARTILE QUARTILE Returns the quartile of a data set.
RANK RANK Returns the rank of a number in a list.
RSQ RSQ Returns the value of the coefficient of determination R ^ 2 of a linear regression.
SKEW SKEW Returns the skewness of a distribution.
SLOPE SLOPE Returns the slope of a linear regression line.
SMALL SMALL Returns the k-th smallest value in a data set.
CENTREE.REDUITE STANDARDIZE Returns a z-value.
STDEV STDEV Evaluates the standard deviation of a population based on a sample of that population.
STDEVA STDEVA Evaluates the standard deviation of a population based on a sample of the population, numbers, text and logical values.
STDEVP STDEVP Calculates the standard deviation of a population from the entire population.
STDEVPA STDEVPA Calculates the standard deviation of a population from the total population, numbers, text and logical values.
STEYX STEYX Returns the standard error of the predicted y value for each x in the regression.
TDIST TDIST Returns the probability of a random variable T Student law.
TINV TINV Returns for a given probability, the value of a random variable T Student law.
TREND TREND Returns values ​​compared to a linear trend.
TRIMMEAN TRIMMEAN Returns the average of the interior of a series of data.
TTEST TTEST Returns the probability associated with a Student T test.
VAR VAR Calculates the variance on the basis of a sample.
VARA VARA Estimates the variance of a population based on a sample of the population, numbers, text and logical values ​​included.
VARP VARP Calculates the variance based on the entire population.
VARPA VARPA Calculates the variance of a population based on the entire population, numbers, text and logical values.
WEIBULL WEIBULL Returns the probability of a random variable following a Weibull distribution.
ZTEST ZTEST Returns the one-tailed probability value of a z test.
Text Functions Text functions
ASC ASC Change English characters or full-width katakana (double-byte) within a string to half-width characters (byte).
BAHTTEXT BAHTTEXT Converts a number to text using currency format ß (baht).
BECAUSE CHAR Returns the character specified by the numeric code.
CLEAN CLEAN Deletes all text control characters.
CODE CODE Returns the code of the first character of the text.
CONCATENATE CONCATENATE Assemble multiple text elements so as not form one.
EURO DOLLAR Converts a number to text using currency format € (euro).
EXACT EXACT Checks if two text values ​​are identical.
FOUND, TROUVERB FIND, FINDB Is a text value within another, case sensitive.
FIXED FIXED Converts a number to text with a specified number of decimal places.
JIS JIS Change English characters or half-width katakana (byte) within a string at full width characters (DBCS).
LEFT, GAUCHEB LEFT, LEFTB Returns the characters on the far left of a string.
LEN, LENB LEN, LENB Returns the number of characters in a text string.
SMALL LOWER Converts text to lowercase.
MID, STXTB MID, MIDB Returns a specified number of characters from a text string from the location you specify.
PHONETICS PHONETIC Extracts the phonetic characters (furigana) of a text string.
PROPER PROPER Capitalizes the first letter of each word in a text string.
REPLACE REMPLACERB REPLACE, REPLACEB Replaces characters within text.
REPT REPT Repeats text a number of times.
RIGHT DROITEB RIGHT, RIGHTB Returns characters to the extreme right of a string.
SEARCH, CHERCHERB SEARCH, SEARCHB Find a text in another text (case-insensitive).
SUBSTITUTES SUBSTITUTE Replaces the old text of a string with a new one.
T T Converts its arguments to text.
TEXT TEXT Converts a number to text.
TRIM TRIM Deletes text areas.
CAPITAL UPPER Converts text to uppercase.
VALUE VALUE Converts a text argument to a number