Excel 2007 features French-English

Check out our new  Excel training courses in Brussels  via TalentWire House Training

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 expressed in a currency of 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 register ID of the dynamic link library that was specified or code resource that has been previously set registry.
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 of KPI and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit margin or quarterly employee turnover, used to evaluate the performance of a company.
MEMBRECUBE CUBEMEMBER Returns a member or tuple in a cube hierarchy. Use this 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 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 the member placed in a row in a set. Use to return one or more elements of a set, such as top sellers or top 10 students.
JEUCUBE CUBESET Defines a calculated set of members or tuples by sending a defined term to 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 the 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 of 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 in the database that match the criteria.
DVAR PSUs Calculates the variance for a sample of database entries of selected data.
DVARP DVARP Calculates the variance for an entire population of selected database entries.
Date and Time Functions Date and time functions  
DATED DATED Returns the serial number of a particular date.
DATEVALUE DATEVALUE Converts a date represented in text form serial number.
DAY DAY Converts a serial number in 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 start_date argument), corrected or down the specified number of months.
EOMONTH EOMONTH Returns the sequential number of the last day of the month before or after the start_date the specified number of months.
HOUR 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.
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 working days.
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.
COMPLEX 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 number to octal.
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 Test 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.
IMDIV 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.
IMSUB 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.
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 which 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 by using a depreciation coefficient.
AMORLINC AMORLINC Returns the depreciation of an asset at the end of a given tax period.
COUPDAYBS COUPDAYBS Returns the number of days between the beginning of the coupon period to the settlement date.
NB.JOURS.COUPONS 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 coupon date after the date of liquidation.
COUPNCD. COUPNCD Returns the first coupon date after the settlement date.
NB.COUPONS 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 depreciation fixed rate.
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 euro price, expressed as a fraction of a euro price expressed as a decimal number.
DOLLARFR DOLLARFR Converts a euro price, expressed as a decimal number, into a euro 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 for a fully invested security.
IPMT IPMT Calculate the amount of interest on an investment for a given period.
SORTING IRR Calculates the internal rate of return of an investment for a succession of treasuries.
ISPMT ISPMT Calculate 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 with 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 PPMT 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 with a face value of 100 euros and that pays interest at maturity.
GO PV Calculates the present value of an investment.
RATE MISSED 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 given period.
SYD SYD Calculates the depreciation of an asset for a given period based on the sum-of-years' digits (declining balance decreasing rate applied to 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 nominal 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 depreciation fixed rate.
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 periodic interest.
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 about the formatting, location and content of a cell.
ERROR.TYPE ERROR.TYPE Returns a number corresponding to an error type.
INFORMATION INFO Returns information about the current operating environment.
IS EMPTY ISBLANK Returns TRUE if the value is empty.
ISERR ISERR Returns TRUE if the value refers to any error value except # N / A.
ISERROR ISERROR Returns TRUE if the value refers to an error value.
ISEVEN ISEVEN Returns TRUE if the number is even.
ISLOGICAL ISLOGICAL Returns TRUE if the value refers to a logical value.
ISNA ISNA Returns TRUE if the value refers to the error value # N / A.
ISNONTEXT ISNONTEXT Returns TRUE if the 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 the 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.
IF IF Specifies a logical test to perform.
IFERROR IFERROR Returns a value you specify if a formula generates an error; otherwise it returns the result of the formula.
NO NOT  Reverses the logic of this argument.
OR GOLD Returns TRUE if any argument is TRUE.
TRUE TRUE Returns logical TRUE.
Research and reference functions Lookup and reference functions  
ADDRESS ADDRESS Returns a reference as text to a single cell of a spreadsheet.
AREAS AREAS Returns the number of areas in a reference.
TO CHOOSE CHOOSE Chooses a value from a list.
COLUMN COLUMN Returns a reference column number.
COLUMNS COLUMNS Returns the number of columns in a reference.
HLOOKUP HLOOKUP Searches 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 array.
INDIRECT INDIRECT Returns a reference indicated by a text value.
RESEARCH LOOKUP Search for values ​​in a vector or matrix.
MATCH MATCH Search for values ​​in a reference or array.
SHIFT OFFSET Returns a reference offset in relation to a given reference.
LINE ROW Returns the reference of a 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: working with objects on 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 Searches in the first column of an array and moves across the row to return the value of a cell.
math 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 arc tangent of a number.
ATAN2 ATAN2 Returns the arc tangent of x and y coordinates.
ATANH ATANH Returns the inverse hyperbolic tangent of a number.
CEILING CEILING Rounds a number to the nearest integer or to the nearest multiple of the 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.
PEER 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 0 (zero).
GCD GCD Returns the greatest common divisor.
ENT INT Rounds a number 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 Gives the round 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.
ROMAN NOVEL Converts Arabic numerals in Roman numbers, as text.
ROUND ROUND Rounds a number to the specified number of digits.
ROUNDDOWN ROUNDDOWN Rounds a number down, toward 0 (zero).
ROUNDUP ROUNDUP Rounds a number to the next higher integer, away from zero.
SERIESSUM SERIESSUM Returns the sum of a geometric series based on the following formula:
SIGN SIGN Returns the sign of a number.
SIN SIN Returns the sine of a given angle.
SINH SINH Returns the hyperbolic sine of a number.
ROOT SQRT Returns the square root of a number.
SQRTPI SQRTPI Returns the square root of (number * pi).
SOUS.TOTAL 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 squares of corresponding values ​​of two matrices.
SUMX2PY2 SUMX2PY2 Returns the sum of the sum of squares of corresponding values ​​of two matrices.
SUMXMY2 SUMXMY2 Returns the sum of the squared differences between the corresponding values ​​of two matrices.
TAN TAN Returns the tangent of a number.
TANH TANH Returns the hyperbolic tangent of a number.
TRUNCATED 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 Binomial.
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-square 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 Count the number of cells that meet a given criteria in a range.
COUNTIFS COUNTIFS Count the number of cells within a range that meet multiple criteria.
COVARIANCE COVAR Returns covariance, the average deviations 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 F probability distribution
FINV FINV Returns the inverse of the probability distribution F
FISHER FISHER Returns the Fisher transformation.
FISHERINV FISHERINV Returns the inverse of the Fisher transformation.
FORECAST FORECAST Calculates a value from a linear trend.
FREQUENCY FREQUENCY Calculates the frequency of occurrence of values ​​in a range of values, and returns the numbers in 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.
INTERCEPT INTERCEPT Returns the intercept of a linear regression line.
KURT KURT Returns the kurtosis of a data series.
GREAT VALUE WIDE 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.
LOGNORMDIST LOGNORMDIST Returns the probability of a continuous random variable following a lognormal.
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.
FASHION FASHION Returns the most common value in a data series.
NEGBINOMDIST NEGBINOMDIST Returns the probability of a discrete random variable following a negative binomial distribution.
NORMAL LAW 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.
PERCENTILE PERCENTILE Returns the k-th percentile of values ​​in a range.
PERCENTRANK PERCENTRANK Returns the percentage rank of a value of a data series.
PERMUTATION 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.
PROBABILITY 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 Evaluate the standard deviation of a population based on a sample of that population.
STDEVA STDEVA Evaluate 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 distribution.
TINV TINV Returns for a given probability, the value of a random variable T Student distribution.
TREND TREND Returns values ​​from a linear trend.
TRIMMEAN TRIMMEAN Returns the average of the inside of a data series.
TTEST TTEST Returns the probability associated with a Student T test.
VAR VAR Calculates variance based on 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 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 katakana to full-width (double-byte) within a string to half-width characters (byte).
BAHTTEXT BAHTTEXT Converts a number to text using currency format ß (baht).
BECAUSE TANK Returns the character specified by the code number.
CLEAN CLEAN Removes all text control characters.
CODE CODE Returns the code of the first character of the text.
CONCATENATE CONCATENATE Joins several text elements so as not to 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 textual value in another case sensitive.
FIXED FIXED Converts a number to text with a specified number of decimal places.
JIS JIS Change English characters or katakana half-width (single-byte) into a character string to full-width characters (double byte).
LEFT GAUCHEB LEFT, LEFTB Returns characters on the far left of a string.
LEN, LENB LEN, LENB Returns the number of characters in a text string.
TINY LOWER Converts text to lowercase.
MID, STXTB MID, MIDB Returns a specified number of characters from a text string from the position you specify.
PHONETIC PHONETIC Extract phonetic characters (furigana) of a text string.
PROPER NOUN PROPER Capitalizes the first letter of each word in a text string.
REPLACE REPLACEB 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 (not case sensitive).
SUBSTITUTED SUBSTITUTE Replaces the old text in a string with a new one.
T T Converts its arguments to text.
TEXT TEXT Converts a number to text.
TRIM TRIM Removes the text field.
CAPITAL UPPER Converts text to uppercase.
VALUE VALUE Converts a text argument to a number