Excel TEXTSPLIT Function – How To Use

The TEXTSPLIT function separates the input text into columns and/or rows as per the given delimiter. The resulting text is spilled into different columns and rows, creating an array. It is one of the most useful Excel functions for text structuring and editing.The TEXTSPLIT function is like the in-built Text to Columns functionality of Excel, … [Read more...]

Excel TEXTJOIN Function – How To Use

The TEXTJOIN function joins text or strings from multiple cells into one cell separating them using the given delimiter with an option to include or ignore empty strings. It was first introduced in Excel 2016.The TEXTJOIN function combines the values while adding the specified delimiter between each text. The return value of the TEXTJOIN function … [Read more...]

Excel NUMBERVALUE Function – How To Use

The NUMBERVALUE function converts a number in text format to numerical format using the given decimal and group separators.The NUMBERVALUE function is very useful when downloading data in different country formats as it converts locale-specific values to locale-independent values.SyntaxThe syntax of the NUMBERVALUE function contains three … [Read more...]

Excel REPLACE Function – How To Use

The REPLACE function replaces the specified number of characters from the string based on the starting position with the mentioned text, string, or value. The REPLACE function is a text function; therefore, the return value is always in text format.The REPLACE function can also be used to remove a part of the string by simply swapping the text … [Read more...]

Excel PROPER Function – How To Use

The PROPER function alters the text into proper case by converting the first letter of each word in a string to uppercase. The first letter is changed to uppercase, and every letter followed by a space, special character, or any character other than a letter is transformed into uppercase.PROPER function in Excel is a text function; therefore, the … [Read more...]

Excel UPPER Function – How To Use

Since Excel doesn't allow the inbuilt functionality of altering case types as Microsoft Word does, the UPPER function helps change the text to capital letters. All lowercase values are transformed to uppercase using the UPPER function. As it is a text function, the return value is always in text format.SyntaxThe syntax of the UPPER function … [Read more...]

Excel LOWER Function – How To Use

The LOWER function in Excel is a text function that converts all other cases to lowercase. The return value of the LOWER function is always a text value. As Excel does not contain an inbuilt 'Change Case' option like Microsoft Word, the LOWER function comes in handy to refine the data as per our needs.SyntaxThe syntax of the LOWER function is … [Read more...]

Excel REPT Function – How To Use

The REPT function in Excel is used to repeat the input text a given number of times. Irrespective of the format of the input text to be repeated, the return value of the REPT function is always a text value.The REPT function is beneficial in creating histograms or in-cell charts for analysis or financial modelling.SyntaxThe syntax of the REPT … [Read more...]