Formula or Macro Needed

[it's an excel world]

Hello all,

I have a report that I export into Excel on a daily basis. One of the columns of data contains a long sting of characters of which I only need a certain part. Each row of data in this column ends with </a>, which I want to drop off and capture all the characters prior to that until I reach the character >. An example is <a href='Default.aspx?PageID=72&PackageHdrID=206066'>1ZV5V4420601084086</a>. All I really want is the 1ZV5V4420601084086.

I wasn't sure if I should use a formula and copy it down the file or create a macro. Please keep in mind that the amount of characters prior to the > is not always the same. But each row does end with </a>. The quantity of rows per export will also very day to day.

Thank you in advance!

 

[VoG]

Try

=MID(A1,FIND(">",A1)+1,LEN(A1)-FIND(">",A1)-2)

 

[it's an excel world]

I changed the -2 to a -4 and it works like a charm!

Thanks for all you help!!!!!!!