Extracting information froma cell

[Dave]

G'day all,

I have an excel file containing information across several colums.
Inside one of the columns (D) is a string which contains
"Genre:xxxxxxx" where x can be any sort of music genre and is not a
given length preceeded and followed by other information. ie) Year:
1999<br>Artist: Talking Heads<br>Genre: Pop<br>Features: Nil

What I would like to do is extract the Genre Information and copy it
to another column (E) so that it's easy to group by genre. However
because the string <br>Genre:xxxxx<br> is never in the same location
inside the column D and because it's length is never the same I'm not
sure how to go about this or whether it's even possible.

The 'outcome' I'm after would be something like this...

|Year: 1999<br>Artist: Talking Heads<br>Genre: Pop<br>Features:
Nil|Pop|

Hopefully someone out there can help!

Cheers
Dave.

 

[Eric]

Dave,

I would start looking into combinations of the =FIND
command. For example, the following formula will extract
the piece of the string starting with "Genre:" and ending
with the "<br>" string no matter where it lies in the
string.

=MID(D1,FIND("Genre:",D1),FIND("<br>",D1,FIND
("Genre:",D1))-FIND("Genre:",D1))

Eric

 

[Dave]

Dave,

I would start looking into combinations of the =FIND
command. For example, the following formula will extract
the piece of the string starting with "Genre:" and ending
with the "<br>" string no matter where it lies in the
string.

=MID(D1,FIND("Genre:",D1),FIND("<br>",D1,FIND
("Genre:",D1))-FIND("Genre:",D1))

Eric

Eric,
this worked a treat - thanks....
Jason your idea was good and would work too but in the relvant column
too many <BR>'s to use as delimiters and I didn't want the information
broken up.
I'm learning alot thanks to your (internet groups) help!

Cheers
Dave.