=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