Extract text in excel

Question

I tried a lot of solutions (found in this website) but unfortunatelly those didn't work. The example: A1 cell contents:

<img src="/images/here/green_apple.jpg" alt="Green Apple - from Midland (123)">

I have to extract texts into 2 cells: B1 cell displays the path: /images/here/green_apple.jpg B2 cell displays the description: Green Apple - from Midland (123)

thanks for help

Scott Craner · Accepted Answer · 2016-04-20 19:45:04Z

3

In B1:

=TRIM(MID(SUBSTITUTE(A1,"""",REPT(" ",99)),99,99))

IN C1:

=TRIM(MID(SUBSTITUTE(A1,"""",REPT(" ",99)),297,99))

answered Apr 20, 2016 at 19:45

Scott Craner

153k10 gold badges52 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Sotech Over a year ago

Thx for the Quick help. After some changes (maybe the Excel different in other language - needed to cange the functions name and "," to ";"). It works perfectly. :)

Scott Craner Over a year ago

@Sotech yes in the US and some other the delimiter is , while in many European and Asian countries it is ; glad you could figure out the issue.

findwindow Over a year ago

You could do it with find but now I see why you did not ^_^ I am never going to grow up to be like you ;_;

Collectives™ on Stack Overflow

Extract text in excel

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related