= RIGHT (A2, 5), function will return " GUPTA" Syntax of "RIGHT" function: =RIGHT (text, ) RIGHT:Return the last character(s) in a text string based on the number of characters specified. =LEFT (A2, 6), function will return "Mahesh" Syntax of "LEFT" function: =LEFT (text,)Įxample:Cell A2 contains the text " Mahesh Kumar Gupta" ![]() ![]() ![]() LEFT: Returns the first character(s) in a text string based on the number of characters specified. To extract the first, middle and last name we use the formulas "LEFT", "RIGHT", "MID", "LEN", and "SEARCH" in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |