computer MS excel

 Text Function

Q. 1 what is text function?

Ans :-

By using format codes to apply formatting to a number, you can alter how it appears when using the TEXT function. It comes in handy when you wish to blend numbers with text or symbols or display numbers in a more understandable style.

Q. 2 Text function name?

Ans :-

1. MID Function

2. FIND Function

3. LEFT Function

4. LEN Function

5. LOWER Function

6. PROPER Function

7. REPT Function

8. SEARCH Function

9. TEXTJOIN Function

10. UPPER Function

11. CHAR Function

12. CONCAT Function

13. TEXT  Function

14. TRIM Function

all function meaning example:-

1. MID Function:-   Based on the number of characters you specify, (MID) returns a certain number of characters from a text string, beginning at the place you designate.

syntax :- MID (text, start position, number _ of _ characters )

example:-

2. FIND Function:-

Find a text string within a second text string, and then return the starting position number of the first text string from the second text string's first character.

syntax:-FIND(find _text, within _text, [start _ num ])

example:-

3. LEFT Function:-

Based on the amount of characters you give, LEFT returns the first character or characters in a text string.

syntax:-=left(text, number _ of _ characters)

example:-

4.LEN Function:-

Use the LEN function, which counts letters, digits, characters, and all spaces, to count the characters in a cell. For instance, "It's 98 degrees today, so I'll go swimming" is 42 characters long (excluding the quotes) and consists of 31 letters, 2 digits, 8 spaces, a comma, and 2 apostrophes.

syntax:- =len (text)

5. LOWER Function:-

Excel's lower() function changes the characters in a string to lowercase. There won't be any conversion if the string of letters is already lowercase. The string of letters will be transformed to lowercase if they are in uppercase (capital).

When there is a lot of text in Excel, the LOWER function can be used as a formula to organise such words. 

syntax:-   =lower(text)

6. PROPER Function:-

capitalises the first letter of a text string as well as any additional letters that come after another character than a letter.

syntax:-  =proper(text)

7. REPT Function:-

Text is repeated a certain amount of times. To place numerous instances of a text string in a cell, use REPT.

syntax:-  =REPT(text, number _times)

example:-

8. SEARCH Function:-

The SEARCH and SEARCHB functions identify a text string within a second text string and return the number of the first text string's starting position calculated from the second text string's first character.

syntax:-  =SEARCHB(find _ text ,within _text,[ start _ num ])

example:-

9. TEXTJOIN Function:-

The TEXTJOIN function joins text values from different ranges and/or strings together, using a delimiter that you define between each value. This function will effectively combine the ranges if the delimiter is an empty text string.

syntax:-  TEXTJOIN(delimiter, ignore empty, text1, [text2], …)

example:-

10. UPPER Function:-

The Excel Text function UPPER Function[1] converts text to uppercase (all capital letters). As a result, the function changes all of the characters in a text string input to upper case.

syntax:- =upper(text)

example:-

11. CHAR Function:-

Returns the character indicated by a number in its description. Use CHAR to convert code page numbers into characters that you might receive from files on different sorts of computers.

syntax:-  = char(number)

example:-

12. CONCAT Function:-

The CONCAT function merges text from different ranges and/or strings, but it doesn't accept delimiter or IgnoreEmpty arguments. The CONCATENATE function is replaced by CONCAT. For Excel versions before to 2010, the CONCATENATE feature will still be available.

syntax:-  CONCATENATE(text1, [text2], ...)

example:-

13. TEXT  Function:-

By using format codes to apply formatting to a number, you can alter how it appears when using the TEXT function. It comes in handy when you wish to blend numbers with text or symbols or display numbers in a more understandable style.

syntax:- =TEXT(Value you want to format, "Format code you want to apply")

example:-

14. TRIM Function:-

Removes all white space from text, save for the solitary gap between words. Text with perhaps erratic spacing that you have obtained from another application should be treated with TRIM.

syntax:-   = trim(text)

example:-