Insert data into cell to the right "IF"

[IGinc]

Column "AC" for now or Column "a" has URL

Some data/urls in column A are incomplete and = "<a href=>

To the right In column AD or Column "b" has the remaining URL to be inserted between "= and >

At the same time many data/urls need to be unchanged as they have the complete data....

Thanks.

 

[IGinc]

Have I explained myself correctly?

 

[Jerry Sullivan]

To make a formula that joins the cells that are incomplete, and ignores the ones that are complete, we need to identify what all the incomplete cells (in Columns A and AC) have in common.
Could you post a couple of examples of complete and incomplete?

 

[IGinc]

examples of A or Ac and B or Ad:

<table width="1234" border="0" cellpadding="0" cellspacing="0"><col style="mso-width-source:userset;mso-width-alt:18944;width:389pt" width="518"> <col style="mso-width-source:userset;mso-width-alt:26185;width:537pt" width="716"> <tbody><tr style="mso-height-source:userset;height:13.5pt" height="18"> <td style="height:13.5pt;width:389pt" width="518" height="18">< a href=http://www.idexonline.com/cp/?di=74216967 ></td> <td style="width:537pt" width="716">http://images.rdidiamonds.com/P59823/P59823.jpg</td> </tr> <tr style="mso-height-source:userset;height:13.5pt" height="18"> <td style="height:13.5pt" height="18">< a href=http://www.idexonline.com/cp/?di=74007958 ></td> <td>http://images.rdidiamonds.com/P58692/P58692.jpg</td> </tr> <tr style="mso-height-source:userset;height:13.5pt" height="18"> <td style="height:13.5pt" height="18">< a href=http://www.idexonline.com/cp/?di=74007331 ></td> <td>http://images.rdidiamonds.com/P58654/P58654.jpg</td> </tr> </tbody></table>
For example I have spaced urls in hopes they would display in column "A/AC"

 

[IGinc]

those that need replacing in A/AC contain only

< a href= >

- Mike

Thanks in advance.

 

[Jerry Sullivan]

Mike,

If I understand you correctly, you can enter this formula in C2 and copy down.

=IF(A2="< a href= >","< a href=" &B2&" >",A2)

Once you have the merged text in Column C you can Copy>PasteSpecial>Paste as Values
to remove the formulas and copy back to Column A.