Remove text in a string

[Melanie_B1]

Hi there,

I am trying to eliminate text that has been returned in a report. This is what has been returned:

xyzcompany.sharepoint.com\/operations\/Pages\/F18-Week-6-Store-Managers-Operations-Update.aspx","UserId":"r.wood@totaltools.com.au","CustomUniqueId":false,"EventSource":"SharePoint","ItemType":"Page","ListId":"604f6a4a-685e-422d-befd-cfc55f935957","ListItemUniqueId":"2d65d1ff-a705-4198-a673-781d221c1b98","Site":"320aeeeb-716c-443a-8596-bd01b8f2a75b","UserAgent":"Mozilla\/5.0 (Windows NT 6.1; WOW64; Trident\/7.0; rv:11.0) like Gecko","WebId":"83380220-8290-4529-991d-daa4b2b20c18"}

Basically, all I want to see is:
F18-Week-6-Store-Managers-Operations-Update

I have gone through the threads to try to find the answer and I tried a couple of the examples but it didn't work for me. I'm barely an intermediate Excel user at best!

Many thanks,
M

 

[Rick Rothstein]

Here is another formula that should work...

=REPLACE(LEFT(A1,FIND(".aspx",A1)-1),1,FIND("Pages\/",A1)+6,"")