Text Between String

[mattyro1]

Good day all,

I was hoping the panel of experts here can assist with a formula to show only data between a string.

within column b2 we I have:

"Opened by Mattyro1 on 6/22/2011 07:41:41 AM"

What I am looking for is a formula to show only Mattyro1.

Anyones assistance is greatly appreciated.

 

[machopicho]

=mid(a1,find("m",a1,1),find(" ",a1,find("m",a1,1))-find("m",a1,1))

 

[T. Valko]

Good day all,

I was hoping the panel of experts here can assist with a formula to show only data between a string.

within column b2 we I have:

"Opened by Mattyro1 on 6/22/2011 07:41:41 AM"

What I am looking for is a formula to show only Mattyro1.

Anyones assistance is greatly appreciated.

One way...

=SUBSTITUTE(LEFT(B2,SEARCH(" on ",B2)-1),LEFT(B2,10),"")

 

[Scott Huish]

=TRIM(MID(LEFT(A1,FIND(" on ",A1)),11,32767))

 

[ukmikeb]

Hi

Assuming the string always begins with "Opened by " then try -

=MID($B2,11,FIND(" on ",$B2)-11)

hth

 

[T. Valko]

One way...

=SUBSTITUTE(LEFT(B2,SEARCH(" on ",B2)-1),LEFT(B2,10),"")

Improvement...

=MID(LEFT(B2,SEARCH(" on ",B2)-1),11,255)