Left, Right or Mid

[How_Do_I]

I'm trying to extract everything after "Check"... What would be the formula to make this robust when I don't know how many characters there are after "Check" please?

Excel Workbook
	L	M	N
6	C:\Users\Gus\Downloads\OOB June 2016\Check\914AHAA.pdf		914AHAA.pdf
Sheet1

 

[Joe4]

You don't need to know. Just choose some value longer than it will ever be. You can just use the Length of L6, i.e.

[COLOR=#000000][FONT=Arial]=MID(L6,SEARCH[/FONT][/COLOR][COLOR=#000000][FONT=Arial]("Check\",L6)[/FONT][/COLOR][COLOR=#000000][FONT=Arial]+6,LEN(L6))[/FONT][/COLOR]

 

[Jonmo1]

Try

=MID(L6,SEARCH("Check",L6)+6,100)


i.e.
It won't error if that number is too large. It will just go to the end of the string.

to be even more robust, you can just use LEN(L6)
=MID(L6,SEARCH("Check",L6)+6,LEN(L6))

 

[Norie]

Change 11 to LEN(L6) in the formula in N6.

=MID(L6,SEARCH("Check",L6)+6,LEN(L6))

 

[Rick Rothstein]

Here is another way where you do not have to specify the length of characters following it...

=REPLACE(A1,1,SEARCH("\check\",A1)+6,"")

Edit Note: Interesting... I had to put the formula in code tags because this forum's comment display box kept removing the backslash when followed by a quote mark.

 

[How_Do_I]

Thanks for your contributions everyone...