Find and trim

**surya9** · 02-25-2010, 06:32 AM

HI

e.g: P12345 123456_2009 Merchant Terminal Reprogramming.

I have around 100 rows with similar format. Need to trim and use only "Merchant Terminal Reprogramming" from the whole of "P12345 123456_2009 Merchant Terminal Reprogramming".
please help...

**rwgrietveld** · 02-25-2010, 06:37 AM

Do you have more than one example? similar format is not very specific.

**arthurbr** · 02-25-2010, 06:41 AM

Hi
Select the data

Ctrl +H

Find what *_????
Replace with (leave blank)

Click Replace all

**surya9** · 02-25-2010, 06:45 AM

P12345 123456_2009 Reporting - Phase
P12345 123456_2009 Merchant Terminal Reprogramming
P12345 123456_2009 .1 Industry and Mandates
P32501 179145_2010.2 Mandates from Card Brands and Debit Networks
P12345 123456_Bucket Moves/Adds and Changes
P32804 181340_Bucket Base Technology

**contaminated** · 02-25-2010, 06:53 AM

Hi

Try this function out

=TRIM(MID(A1,MIN(SEARCH({"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"},MID(A1,2,255)&"ABCDEFGHIJKLMNOPQRSTUVWXYZ"))+1,255))

POST HAS BEEN EDITED