| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trim data in Excel 2003
Hi there
I am trying to figure out if there is a way of getting the 'Desired output' using Excel formula..see link for the actual spreadsheet. Any tips/help would be greatly appreciated/ -Usman http://spreadsheets.google.com/ccc?k...QA-0eWNUvuTvbA Input Data Desired Output Current solution aperio_best_plan_subscriber_extract_24095_2009-03-18-20-01-43.log.gz aperio_best_plan_subscriber_extract aperio_best_plan_subscribe LEFT(A1,LEN(RIGHT(A1,26))) test_best_asd_subscriber_extract_245_2009-03-18-20-01-43.log.gz test_best_asd_subscriber_extract test_best_asd_subscriber_e test_subscriber_extract_240121295_2009-03-18-20-01-43.log.gz test_subscriber_extract test_subscriber_extract_24 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trim data in Excel 2003
=LEFT(A1,FIND("extract",A1)+7)
On 15 Kwi, 14:14, wrote: Hi there I am trying to figure out if there is a way of getting the 'Desired output' using Excel formula..see link for the actual spreadsheet. Any tips/help would be greatly appreciated/ -Usman http://spreadsheets.google.com/ccc?k...QA-0eWNUvuTvbA Input Data * * *Desired Output *Current solution aperio_best_plan_subscriber_extract_24095_2009-03-18-20-01-43.log.gz aperio_best_plan_subscriber_extract aperio_best_plan_subscribe * * *LEFT(A1,LEN(RIGHT(A1,26))) test_best_asd_subscriber_extract_245_2009-03-18-20-01-43.log.gz test_best_asd_subscriber_extract * * * *test_best_asd_subscriber_e test_subscriber_extract_240121295_2009-03-18-20-01-43.log.gz test_subscriber_extract test_subscriber_extract_24 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trim data in Excel 2003
Sorted!
=LEFT(A13,FIND("_",A13,LEN(A13)-(FIND("_",(RIGHT(A13,26+7)),2)+26))-IF (FIND("_",(RIGHT(A13,26+7)),2)=3,5,IF(FIND("_",(RI GHT(A13,26+7)),2) =2,6,1))) '7' is used as a fiddle factor! On 15 Apr, 13:21, Jarek Kujawa wrote: =LEFT(A1,FIND("extract",A1)+7) On 15 Kwi, 14:14, wrote: Hi there I am trying to figure out if there is a way of getting the 'Desired output' using Excel formula..see link for the actual spreadsheet. Any tips/help would be greatly appreciated/ -Usman http://spreadsheets.google.com/ccc?k...QA-0eWNUvuTvbA Input Data * * *Desired Output *Current solution aperio_best_plan_subscriber_extract_24095_2009-03-18-20-01-43.log.gz aperio_best_plan_subscriber_extract aperio_best_plan_subscribe * * *LEFT(A1,LEN(RIGHT(A1,26))) test_best_asd_subscriber_extract_245_2009-03-18-20-01-43.log.gz test_best_asd_subscriber_extract * * * *test_best_asd_subscriber_e test_subscriber_extract_240121295_2009-03-18-20-01-43.log.gz test_subscriber_extract test_subscriber_extract_24- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trim data in Excel 2003
my (slightly adjusted) formula gives a desired result
=LEFT(A1,FIND("extract",A1)+6) On 15 Kwi, 19:00, wrote: Sorted! =LEFT(A13,FIND("_",A13,LEN(A13)-(FIND("_",(RIGHT(A13,26+7)),2)+26))-IF (FIND("_",(RIGHT(A13,26+7)),2)=3,5,IF(FIND("_",(RI GHT(A13,26+7)),2) =2,6,1))) '7' is used as a fiddle factor! On 15 Apr, 13:21, Jarek Kujawa wrote: =LEFT(A1,FIND("extract",A1)+7) On 15 Kwi, 14:14, wrote: Hi there I am trying to figure out if there is a way of getting the 'Desired output' using Excel formula..see link for the actual spreadsheet. Any tips/help would be greatly appreciated/ -Usman http://spreadsheets.google.com/ccc?k...QA-0eWNUvuTvbA Input Data * * *Desired Output *Current solution aperio_best_plan_subscriber_extract_24095_2009-03-18-20-01-43.log.gz aperio_best_plan_subscriber_extract aperio_best_plan_subscribe * * *LEFT(A1,LEN(RIGHT(A1,26))) test_best_asd_subscriber_extract_245_2009-03-18-20-01-43.log.gz test_best_asd_subscriber_extract * * * *test_best_asd_subscriber_e test_subscriber_extract_240121295_2009-03-18-20-01-43.log.gz test_subscriber_extract test_subscriber_extract_24- Hide quoted text - - Show quoted text -- Ukryj cytowany tekst - - Pokaż cytowany tekst - |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trim data in Excel 2003
try,
=LEFT(A2,FIND("extract",A2)+6) " wrote: Hi there I am trying to figure out if there is a way of getting the 'Desired output' using Excel formula..see link for the actual spreadsheet. Any tips/help would be greatly appreciated/ -Usman http://spreadsheets.google.com/ccc?k...QA-0eWNUvuTvbA Input Data Desired Output Current solution aperio_best_plan_subscriber_extract_24095_2009-03-18-20-01-43.log.gz aperio_best_plan_subscriber_extract aperio_best_plan_subscribe LEFT(A1,LEN(RIGHT(A1,26))) test_best_asd_subscriber_extract_245_2009-03-18-20-01-43.log.gz test_best_asd_subscriber_extract test_best_asd_subscriber_e test_subscriber_extract_240121295_2009-03-18-20-01-43.log.gz test_subscriber_extract test_subscriber_extract_24 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to trim a whole excel sheet? | Excel Worksheet Functions | |||
| Trim and Keep the Trimmed Data | Excel Worksheet Functions | |||
| Excel trim not working | Excel Discussion (Misc queries) | |||
| Trim data in charts | Charts and Charting in Excel | |||
| How can I trim "4|+|23.68^" into "23.68" in excel 2000? | Excel Worksheet Functions | |||
Hybrid Mode
