MID

This function extracts characters from a specified position in the input string.

This function extracts characters from a specified position in the input string to the end of the string. An optional parameter specifies how many characters are extracted. To use this function the format needs to be

MID(input, number [,number of characters returned])

The following example can be entered in the formula expression dialog to return the characters from the 5th character of the string

=MID("PARTCODE",5) which returns CODE

The following can be entered to return the two characters from the 5th character (this includes the 5th character)

=MID("PARTCODE",5,2) which returns CO

You are able to enter a minus value for the optional number of characters so the number is counted back from the character chosen as the position to take the string from

=MID("PARTCODE",5,-3) which returns ARTCODE

Any text containing spaces needs to be contained within "".