EXTRACT FULL NAME
 

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

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

EXTRACT FULL NAME
 

Thank you Jeff for your help, let me see if i can modify the code of the macro


"Jeff" wrote:

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