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