Transcript U.S. Consulting Report Template (Title sentence case 18

Functions: Trim & Left
• Trim Function: removes additional spacing around characters in a cell
Function
=Trim(cell reference)
=TRIM(A1)
Example:
George Washington George Washington
• Left Function: returns a specified number of characters starting from the left of the
reference cell
Function
=Left(cell reference, # of characters to return)
Example:
John Adams
=LEFT(A1,4)
John
-1-
Functions: Right & Mid
• Right Function: returns a specified number of characters starting from the right of the
reference cell
Function
=Right(cell reference, # of characters to return)
Example:
John Adams
=RIGHT(A1,5)
Adams
• Mid Function: returns a specified number of characters starting from a specified spot of
the reference cell
Function
=Mid(cell reference, # of position to begin return from, # of characters to return)
Example:
=MID(A3,6,5)
John Adams
Adams
-2-
Special Uses
• Returning First Names
Function
=Left(reference cell, find(" ",reference cell)-1)
=LEFT(A4,FIND(" ",A4)-1)
Example:
Thomas Jefferson
Thomas
• Returning Last Names
Function
=Mid(reference cell, find(" ",reference cell)+1,number of characters to return)
Example:
Thomas Jefferson
=MID(A1,FIND(" ",A1)+1,30)
Jefferson
-3-