View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default EXTRACT FULL NAME

Maybe this will help

http://www.cpearson.com/Excel/FirstLast.htm

"Noe" wrote:

CAN SOME ONE HELP ME I HAVE EXCELL I NEED TO IDENTIFY THE LETTER FROM THE
COLUMN D "SUMMARY" AND DELETE THE COLUMN AND THE TWO ROWS IS UNDER THE LETTER
SUMMARY HERE IS AN EXEMPLO


01/27/10 537 ALMANZA, JOSE 537 ALMANZA, JOSE - Adherence Summary 0 0
01/27/10 537 ALMANZA, JOSE Signon 128:26:00 129:07:00 7706 7747
01/27/10 537 ALMANZA, JOSE Signoff 27:49:00 36:36:00 1669 2196
SING IN AND SING OFF ITS THE ACUMULATIVE AN I JUST WANT DELETED BUT ONLY
THOSE ARE WITH ADHERENCE SUMMARY


I HOPE SOME ONE CAN HELP ME I WILL BE APPRECIATE THANK YOU