ferocious12
Member
Hi All,
I have text in cell A1 & A2 and I need to extract specific text from it.
Cell A1 - the text I have to extract is always located at the end between ".jpg" and last "/"
Cell A2 - the text I have to extract is always located between "https://www.arabia.com/" and ".html". In addition I have to delete the "-" between the text.
Please see attached file and image below showing what i want to achieve in cells B1 & B2
Can you please help.
I have text in cell A1 & A2 and I need to extract specific text from it.
Cell A1 - the text I have to extract is always located at the end between ".jpg" and last "/"
Cell A2 - the text I have to extract is always located between "https://www.arabia.com/" and ".html". In addition I have to delete the "-" between the text.
Please see attached file and image below showing what i want to achieve in cells B1 & B2
Can you please help.