Question

•
The 5 sign is used for a sulle le
Text formulas involve concatenation of text
strings.
Wh
* EXERCISES
im
scriptive Type Questions
Inswer the following.
What is a circular reference? Explain with an example.
Write the steps to find the LCM of three numbers.
The two ways of entering a cell reference in a formula are (a) by typing and (b) by poin
Explain the difference between the two methods.
The Insert Function button is us.
and calculating functions in a w​

Answer 1

Answer:

Excel is mostly about the numerical data, but at times you can come across the data which has too much text and that is the time when Text Functions in Excel will help you to simplify the things easily.

Here are few text functions you should know

 

1.Left()

You can use the Left function when you want to extract the leftmost characters from a string. Syntax =left(text, num_char)



Similarly, you can also use the Right function to extract the rightmost characters from a string.



2.  Len ()

Len function in Excel helps you to know the length of a string that is number of characters in a string. Syntax = LEN(text)

Note – Spaces are included while calculating length.



3.  Mid ()

Mid function in Excel is used to extract the characters from the middle of a string. Syntax = MID(text, start_char, num_chars)



4.  Find ()

Find function in Excel is used when you want to know the position of certain characters in a particular string. Syntax =FIND(find_text, within_text,[start_num])

Explanation:

HOPE MY ANSWERS HELPS U IF U HAD PLZZZ BRAINLIST ME AND FOLLOW ME