| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract first name only from full name | Excel Worksheet Functions | |||
| Matching CELL text (full word) to full word in string in another | Excel Programming | |||
| extract filename from full path | Excel Programming | |||
| Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
| Extract full path given filename | Excel Programming | |||
Linear Mode
