second set excel function implementations

[mmsesay]

1. MID: The Excel MID function extracts a given number of characters from the middle of a supplied text string. For example, =MID("apple",2,3) returns "ppl". =MID (text, start_num, num_chars)

2.REPLACE: To replace text by position. REPLACE removes the two asterisks (**) by replacing the first two characters with an empty string ("").

3. SEARCH: return the numeric position of matching text. =SEARCH(B4,C4)

4. ABS: The Excel ABS function returns the absolute value of a number. Negative numbers are converted to positive numbers, and positive numbers are unaffected. =ABS(number)

5. EXACT: allows you to compare two text strings in a case-sensitive manner. =EXACT(C5,D5) -> True / False