View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ChuckF ChuckF is offline
external usenet poster
 
Posts: 20
Default Delete first two characters in a cell...

I have a spreadsheet which shows the first inital and a space for
everyone in our company. I am trying to cut that down to simply show
the last name. Can anyone help me delete the first two characters
(first initial and the space) from a spreadsheet like this?

A Smith
A Thomas
B Patterson
C Jones

I want to return the following:
Smith
Thomas
Patterson
Jones