Results 1 to 9 of 9

How Do I extract specific data from one cell to another?

Threaded View

  1. #1
    Registered User
    Join Date
    02-02-2009
    Location
    BC, Canada
    MS-Off Ver
    Excel 2007
    Posts
    8

    How Do I extract specific data from one cell to another?

    Hello I was reading a recent post by you on how to extract certain data from a cell. I was wondering if you would also know how to do the following. I have an ecommerce store and need to extract certain data from my dealers. Here's and eg.
    Cell info
    <p><br /><img height=351 width=500 border=0 src=http://www.tpg.com/paintball/images/T68/T68_True_Target_Marker_LF.jpg /><br /><br /><br /><img height=371 width=500 border=0 src=http://www.tpg.com/paintball/images/T68/T68_True_Target_Marker_LB.jpg /><br /></p><table width=500 cellspacing=0 cellpadding=0 border=0 id=table1> <tbody> <tr> <td><font face=Arial size=2>The T68 True Target Package is all metal construction. This unit is built for fast rapid action. Built with the <a href=http://www.tpg.com/os/product_info.php/products_id/63>True Target Point Sight</a> you are in complete control of each shot..</font></td> </tr> </tbody></table><p><font face=Arial size=2><br /></font></p><p><font face=Arial size=2 color=#ff0000><font face=arial size=2><b>Available Options</b></font><table height=293 id=table2> <tbody> <tr> <td height=9 width=75 valign=center><b><font face=Arial size=2>Option 1:</font></b></td> <td height=9 width=409><font face=Arial size=2>There are 9 different air options to choose from: <a target=_new href=http://www.tpg.com/paintball/t68_air_system.html><font face=Arial size=2 color=#0000ff>View the different air system available here</font></a></font></td> </tr> <tr> <td height=12 width=75 valign=center><b><font face=Arial size=2>Option 2:</font></b></td> <td height=12 width=409><font face=Arial size=2>Your marker comes with a 14&quot; Tactical barrel, you can upgrade your barrel to rifled version for better performance. You can </font><a target=_new href=http://www.tpg.com/paintball/os/barrel-systems-tactical-rifled-barrel-c-22_220_388.html><font face=Arial size=2 color=#0000ff>view the different barrels and specs here</font></a></td> </tr> <tr> <td height=40 width=75 valign=center><b><font face=Arial size=2>Option 3:</font></b></td> <td height=40 width=409><font face=Arial size=2>With this 200 rounds hopper adaptor and you can change out your magazine fed marker to use a hopper</font></td> </tr> <tr> <td height=11 width=75><b><font face=Arial size=2>Option 4:</font></b></td> <td height=11 width=409><font face=Arial size=2>This kit comes with all the o-rings to completely rebuilt your marker</font></td> </tr> <tr> <td height=2 width=75><b><font face=Arial size=2>Option 5:</font></b></td> <td height=2 width=409><font face=Arial size=2>This tool kit has all the tools for you to service your marker</font></td> </tr> <tr> <td height=21 width=75><b><font face=Arial size=2>Option 6:</font></b></td> <td height=21 width=409><font face=Arial size=2>Extend your manufacture warranty to 3 years</font></td> </tr> <tr> <td height=21 width=75><b><font face=Arial size=2>Option 7:</font></b></td> <td height=21 width=409><font face=Arial size=2>Add additional magazines to your package</font></td> </tr> <tr> <td height=40 width=75><b><font face=Arial size=2>Option 8:</font></b></td> <td height=40 width=409><font face=Arial size=2>Add a hard cover carrying case to protect your marker. This is an excellent storage case. </font><a target=_new href=http://www.tpg.com/paintball/os/rap4-paintball-marker-p-4330.htm><font face=Arial size=2 color=#0000ff>View the case here</font></a></td> </tr> <tr> <td height=21 width=75><b><font face=Arial size=2>Option 9:</font></b></td> <td height=21 width=409><font face=Arial size=2>Additional 5oz cylinder to your package</font></td> </tr> </tbody></table></font></p><p>&nbsp;</p><br><b>Package Includes:</b><br>- 1 x T68 M4 Gen6 - Magazine Fed Paintball Gun ( <a href=\t68-paintball-gun-magazine-fed-c-21_143_340.html\> more info</a> ) <br />- 1 x 5 Year Warranty<br />- 1 x <a href=\product_info.php/products_id/1129\>20mm Rail<br /></a> - 1 x <a href=\vertical-grip-black-p-301.html\>RIS Vertical Grip</a><br />- 1 x <a href=\product_info.php/products_id/146\>M4 Scope Base Mount</a><br />- 1 x <a href=\product_info.php/products_id/63\>True Target Point Sight<br /></a> - 1 x <a href=\advanced_search_result.php?keywords=exacto&amp;inc_subcat=1&amp;Search=Search\> Exacto Laser Sight</a>
    End of Cell data
    It will be like this for a full column. What I need is to be able to pull the very first image url from the text into another cell and colum. I then need all the info from the "Package Includes" into another cell and column. Please let me know if you know how to do this.
    Thank you
    Last edited by VBA Noob; 04-18-2009 at 04:33 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1