Extracting information froma cell

  • Thread starter Thread starter Dave
  • Start date Start date
D

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.
 
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 said:
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
Click to expand...

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.
 
Back
Top