Big Find and replace knightmareorama

[si666]

Hi, I’ve been having a bit of an ongoing nightmare with a find and replace on a csv file saved as an excel spreadsheet.
I have some html code (well quite a lot really) in the cells of a column named description. An example of which I have included bellow. To cut a long and painful story short I need to fin and replace alt=” with alt=”” but the cells also contain alt=”something here”.
Not only can I not work out how to write the find and replace for this, I don’t even appear to be able to do any find which highlights the part of the cells contents I wand to find, it jus highlights the cell. Also when I try a find and replace of any type with a word I know to be in the cell I get cannot find the data you’re searching for message.(I only have the formulas option in the Look in dropdown box).
I would greatly appreciate any kind of help with this as it may soon send me crazy.

Thanks for any help.

<table width="520" cellspacing="0" cellpadding="1" border="0">      <tbody>          <tr>              <td width="271" valign="top" height="45">              <table width="243" border="0" id="sizetable">                  <tbody>                      <tr>                          <th colspan="2">Select your size & style </th>                      </tr>                      <tr class="sizeon">                          <td width="235"> 30" Regular (selected) </td>                      </tr>                      <tr>                          <td> 32"  Regular </td>                      </tr>                      <tr>                          <td> 34" Regular  </td>                      </tr>                      <tr>                          <td> 36" Regular </td>                      </tr>                      <tr>                          <td>30" Long </td>                      </tr>                      <tr>                          <td>32" Long </td>                      </tr>                      <tr>                          <td>34" Long </td>                      </tr>                      <tr>                          <td style="border-bottom-style: none;">36" Long </td>                      </tr>                  </tbody>              </table>              </td>              <td width="250" valign="top" rowspan="2" class="flash"><object width="250" height="250" align="middle" id="imagezoom" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000">              <param value="/ekmps/shops/rajan/resources/Flash/imagezoom.swf?image=/ekmps/shops/rajan/resources/Image/MJN-WORK07-ZOOM.jpg&imagebig=/ekmps/shops/rajan/resources/Image/MJN-WORK07-LARGE.jpg&imgW=250&imgH=250" name="movie" />              <param value="false" name="loop" />              <param value="false" name="menu" />              <param value="high" name="quality" />              <param value="#ffffff" name="bgcolor" /> <embed width="250" height="250" align="middle" src="/ekmps/shops/rajan/resources/Flash/imagezoom.swf?image=/ekmps/shops/rajan/resources/Image/MJN-WORK07-ZOOM.jpg&imagebig=/ekmps/shops/rajan/resources/Image/MJN-WORK07-LARGE.jpg&imgW=250&imgH=250" loop="false" menu="false" quality="high" bgcolor="#ffffff" name="imagezoom" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer"></embed></object></td>          </tr>          <tr align="left">              <td valign="top" height="83">              

Men’s 100% cotton cross fire denim jeans. </p>              

[ekm:productprice][/ekm:productprice]</p>              

 /ekmps/shops/rajan/resources/Image/braveSoul.gif</p>              </td>          </tr>      </tbody>  </table>  <table width="620" height="97" border="0">      <tbody>          <tr valign="bottom">              <td width="150" height="73" class="cartSize">[ekm:addtocart][/ekm:addtocart]</td>              <td width="150" class="cartSize">/ekmps/shops/rajan/resources/Image/sizeGuide.jpg</td>              <td width="320" class="cartSize"> </td>          </tr>          <tr>              <td height="24" colspan="2">              <div align="left"><font size="1"><font size="2" face="Arial, Helvetica, sans-serif"><font size="2" face="Courier New, Courier, mono" color="#003300"> [ekm:emailtofriend]
              <font size="2" face="Courier New, Courier, mono" color="#000066">    button='No';
                  linktext='Email to a Friend';
                  message='I found this and thought of you.';
                  backgroundcolour='#FFFFFF';
              </font>[/ekm:emailtofriend]</font></font></font></div>              </td>              <td> </td>          </tr>      </tbody>  </table>  

</p>  <hr />  

</p>  <h3>Additional Information</h3>  

-</p>  <h3>Care Instructions</h3>  


		
		
	


	

		
	

		
	

		
	

		
	

		
	
     Care codes explained</p>  <hr />  <table width="620" border="0" id="alsobought">      <tbody>          <tr>              <th colspan="4">              <h3>Take a look at these other bargains.</h3>              </th>          </tr>          <tr>              <td width="503" height="25%">/ekmps/shops/rajan/resources/Image/MJK-441207-DKCH-SMALL.jpg</td>              <td width="25%">/ekmps/shops/rajan/resources/Image/MK-034278-BK-SMALL.jpg</td>              <td width="25%">/ekmps/shops/rajan/resources/Image/MJN-RUFF07-SMALL.jpg</td>              <td width="25%">/ekmps/shops/rajan/resources/Image/MSS-53STAR-SMALL.jpg</td>          </tr>          <tr>              <td height="24">              <div align="left">Show me</div>              </td>              <td>              <div align="left">Show me </div>              </td>              <td>              <div align="left">Show me </div>              </td>              <td>              <div align="left">Show me</div>              </td>          </tr>      </tbody>  </table>

 

[Andrew Poulsom]

It seems to me that you need to find 'alt=” ' (no single quotes) and replace with 'alt=”" ' (no single quotes) - ie put a space on the end. And you need to look in Values.

 

[Stormseed]

It seems to me that you need to find 'alt=” ' (no single quotes) and replace with 'alt=”" ' (no single quotes) - ie put a space on the end. And you need to look in Values.

Sir, atleast you understood the question ! People like me, do not stand a chance