Which function deals with text?

1.	Which function deals with text?
Answer» Explanation: Text Functions in Excel Len () Len FUNCTION in Excel helps you to know the length of a string that is number of CHARACTERS in a string. ... Mid () Mid function in Excel is used to EXTRACT the characters from the middle of a string. ... FIND () ... Proper () ... Rept () ... TRIM() ... Upper() ... Substitute ()

Answer»

Explanation:

Text Functions in Excel

Len () Len FUNCTION in Excel helps you to know the length of a string that is number of CHARACTERS in a string. ...

Mid () Mid function in Excel is used to EXTRACT the characters from the middle of a string. ...

FIND () ...

Proper () ...

Rept () ...

TRIM() ...

Upper() ...

Substitute ()

Discussion