How do I delete text before the last forward slash in a column in excel?
Formula
=TRIM(RIGHT(SUBSTITUTE(A1,”/”,REPT(” “,LEN(A1))),LEN(A1)))
Example
List of URLs
https://www.logitech.com/en-us/products/webcams/brio-4k-hdr-webcam.html
https://www.logitech.com/en-us/products/headsets/zone-wired-noise-canceling.html
https://www.logitech.com/en-us/products/video-conferencing/room-solutions/swytch.html
https://www.logitech.com/en-us/products/education/ipad-solutions/rugged-combo-3.html
https://www.logitech.com/en-us/products/video-conferencing/conference-cameras/meetup-conferencecam.html
https://www.logitech.com/en-us/products/video-conferencing/room-solutions/rallybar.html
https://www.logitech.com/en-us/products/education/ipad-solutions/crayon.html
https://www.logitech.com/en-us/products/video-conferencing/accessories/pc-mount-minipc-chromebox.html
https://www.logitech.com/en-us/products/video-conferencing/room-solutions/rallybarmini.html
https://www.logitech.com/en-us/products/video-conferencing/room-solutions/microsoft-teams-rooms-android.html
Output
brio-4k-hdr-webcam.html
zone-wired-noise-canceling.html
swytch.html
rugged-combo-3.html
meetup-conferencecam.html
rallybar.html
crayon.html
pc-mount-minipc-chromebox.html
rallybarmini.html
microsoft-teams-rooms-android.html