Extracting Specific Text

[howard]

I would like to extract Run09 as well as the date after the last _ i.e Run09 22/08/2011

MAN_Rep_Run09_22/08/2011

I have used =MID(A15,FIND("Run",A15),FIND("_",A15)-FIND("Run",A15)+21), but cannot get the underscore removed

It results in Run09_22/08/2011

Your assistance in this regard will be most appreciated

 

[anandvarma]

try this

Excel Workbook
	A
1	MAN_Rep_Run09_22/08/2011
2	Run09 22/08/2011
Sheet1

 

[howard]

Thanks for the help, formula works perfectly

 

[anandvarma]

i glad it helped you

thanks for the feed back