by Rajesh Saraogi | Jul 16, 2020 | Functions
Description REPT is a text function in Excel. Having two arguments and both are mandatory. First one is text, the text string you want to repeat and second is number_times, number of times you want to repeat the text string Syntax REPT(text, number_times) Example REPT...
by Rajesh Saraogi | Jul 16, 2020 | Functions
Description REPLACE is a text function in Excel. Use it to replace one or more character from a text string with different character(s). This function has four arguments all are mandatory,first is old_text from which you want to replace the character(s). Second is...
by Rajesh Saraogi | Jul 16, 2020 | Functions
Description NUMBERVALUE is a text function in Excel. Use it to convert a number in text format to number. Having three arguments where first one is mandatory and other two are optional. In first argument text you need to give number in text format you want to convert,...
by Rajesh Saraogi | Jul 16, 2020 | Functions
Description MID is a text function in Excel. Having three arguments, all are mandatory. First is text the text string from which you want to extract the character(s). Second is start_num, the specific position to start and the last is num_chars, number of character(s)...
by Rajesh Saraogi | Jul 16, 2020 | Functions
Description LOWER is a text function in Excel. It converts all uppercase letters into lowercase, ignoring numbers and punctuation Syntax LOWER(text) Example LOWER Excel function converts the uppercase characters into lowercase ignoring space, numbers and...
by Rajesh Saraogi | Jul 16, 2020 | Functions
Description LEN is a text function in Excel. It returns number of characters or length of a text string. LEN returns length of a number or date without considering formatting. It count space as a character Syntax LEN(text) Example LEN Excel function returns the number...
