Microsoft Excel Functions & Formulas

Use the MID function to separate last name

from first name

In a worksheet, names are listed in column A, and the last name

has to be copied to column B. As in the previous example, the

space between the first and last names has to be determined with

the SEARCH function. This function returns the position of the

desired character inside a text string starting from start_num. The

MID function then returns a specific number of characters starting

from a desired position inside a text string.

MID(text, start_num, num_chars)

text: Text string containing the desired characters.

start_num: Position of the first character to extract from the

text.

num_chars: Number ...