The REPT function Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string. REPT(text, number_times) The REPT function syntax has the following arguments: Text Required. The text you want to repeat. Number_times Required. A positive number...
The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols. =TEXT(Value you want to format,...
A B C D E 1 2 3 4 Data Kazam BD123 Formula Description (Result) =IF(ISNUMBER(SEARCH("m",A2)),"OK", "Not OK") Checks to see if A2 contain the letter m (OK) =ISNUMBER(SEARCH("BD",A3)) Checks to see if A3 contains BD (TRUE) =IF(ISNUMBER(FIND("M",A2)),"OK", "Not OK") Checks to see if A2...
Data Kazam BD123 Formula Description (Result) =IF(ISNUMBER(FIND("m",A2)),"OK", "Not OK") Checks to see if A2 contain the letter m (OK) =ISNUMBER(FIND("BD",A3)) Checks to see if A3 contains BD (TRUE)
Data Kazam Formula Description =IF(A2="Kazam","OK", "Not OK") Checks to see if A2 is Kazam (OK) =IF(A2="Raza", TRUE, FALSE) Checks to see if A2 is Raza (FALSE)
Data Kazam 123 Formula Result Description =ISTEXT(A2) TRUE Checks to see if cell A2 has text (TRUE) =ISTEXT(A3) FALSE Checks to see if cell A3 has text (FALSE)
Name kazam RAZA Formula Result Description =UPPER(A2) KAZAM RAZA Changes text to all UPPERCASE =LOWER(A2) kazam raza Changes text to all lowercase =PROPER(A2) Kazam Raza Changes text to Title Case
