Microsoft Excel 2010
To copy (extract) only part of a cell's contents, try the LEFT or MID function. The Left function will extract characters from the left of a cell, the MID function will extract characters within a cell.
To extract only the first few characters of a cell:
Example: If cell A1 contains the number 456789, the command =LEFT(A1,3) will produce 456.
To extract part of a cell:
Example: If cell A1 contains the number 456789, the command =MID(A1,3,2) will produce 67. The 3 refers to the third character. The 2 refers to how many characters to include.