Question

the______ character is used in text formula​

Answer 1

Answer:

To extract the characters, words, first, middle and last name from a cell, we use the formulas “LEFT”, “RIGHT”, “MID”, “LEN”, and “SEARCH” in Microsoft Excel. LEFT: Returns the first character(s) in a text string based on the number of characters specified.

Answer 2

string character or & .

Hope it helps you