Suppose I needed to extract theexceltrainer.co.uk from this string:
https://theexceltrainer.co.uk/excel-extract-text-between-characters
I published a video back in 2022 that covered how to do it. There were 2 options – use a long-winded formula or use Power Query. However if you’re a Microsoft 365 user there’s now a much simpler way, using a combination of 2 relatively new functions – TEXTBEFORE and TEXTAFTER
=TEXTBEFORE(TEXTAFTER(A1, “//”), “/”)
If you’re using an older version of Excel and you don’t have these functions, check out the original video.
But if you have Excel 365 and want a simple way to extract text between characters, check out the video below:
Download a copy of the file(s) used in this video: https://share.zight.com/12um6bo4