View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patrick C. Simonds Patrick C. Simonds is offline
external usenet poster
 
Posts: 343
Default Return first 2 numbers of a cell

I have been given a list of 2080 employees with there employee number
81SIMOPC. All I need is the number preceding the letters. The employee
number is in column A, is there any formula which would return just the 2
numbers at the beginning of the employee number in column B?