Good evening Forum and Happy New Year:
I am trying to insert anchor/hyperlink I have in column A inside cells that contain product descriptions.
Anchor Text I have in column A are 73 and in column B with descriptions of products I have about 1800 products.
I like to insert automatically the anchor texts inside the description so I can upload the description back into the ecommerce for Search Engine optimization pourposes.
As an example I show Column A (Anchor Text/ Hyperlink) 100% Cotton.
In column B (Description) I found manually to 100% cotton without hyperlink. I am looking for some formula or function that allows me replace the words in column B with the words with hyperlink from column A.
Thank you for any advise, Rafael.
<style type="text/css"><!-- body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Liberation Sans"; font-size:x-small } --> </style>
<tbody>
[TD="align: left"]Anchor[/TD]
[TD="align: left"]Description[/TD]
[TD="align: left"] 100% cotton [/TD]
[TD="align: left"]3-ounce 60/40 cotton/polyGently contoured silhouetteOpen collar with ruffled Y-shaped slim placketFront and back darts3/4 sleeves with cuffsPearlized smoke buttons pearlized white buttons on Chambray Blue and Pink Orchid[/TD]
[TD="align: left"]Woven Shirts[/TD]
[TD="align: left"]4-ounce 100% polyester interlock Wicks and dries quickly 50+ UPF rating Tag-free label Narrow ribbed collar Double-needle coverseamed neck Double-needle sleeves and hem[/TD]
[TD="align: left"]T-Shirts[/TD]
[TD="align: left"]4-ounce 100% polyester interlock Wicks and dries quickly 50+ UPF rating Tag-free label Narrow ribbed collar Double-needle coverseamed neck Double-needle sleeves and hem[/TD]
[TD="align: left"]Accessories[/TD]
[TD="align: left"]4.5-ounce 100% cotton Deluxe 30-singles Softstyle yarns Junior contoured silhouette with side seam Feminine double-needle 1/2 rib knit seamless collar Double-needle sleeves and hemSports Grey 90/10 cotton/poly.[/TD]
[TD="align: left"]Activewear[/TD]
[TD="align: left"]4.5-ounce 100% cotton Deluxe 30-singles Softstyle yarns Seamless double-needle 3/4 neck Taped neck and shoulders Rolled forward shoulders for better fit Double-needle sleeves and hem Antique Heliconia Antique Sapphire and Sports Grey 90/10 cotton/poly.Dark Heather Heather Irish Green Heather Military Green Heather Navy Heather Orange Heather Purple and Heather Royal 35/65 cotton/poly.[/TD]
[TD="align: left"]Outerwear[/TD]
[TD="align: left"]4.5-ounce 100% polyester AquaFX moisture wicking Freshcare anti-odor properties Heat transfer label Rib knit 1/2 non-topstitched collar Side seamed with tapered fit Double-needle sleeves and hem Safety Green is compliant with ANSI/ISEA 107 high visibility standards for background color[/TD]
[TD="align: left"]Bags[/TD]
[TD="align: left"]4.5-ounce 100% polyester AquaFX moisture wicking Freshcare anti-odor properties Heat transfer label Rib knit 3/4 non-topstitched collar Double-needle sleeves and hem Safety Green is compliant with ANSI/ISEA 107 high visibility standards for background color[/TD]
</tbody>
I am trying to insert anchor/hyperlink I have in column A inside cells that contain product descriptions.
Anchor Text I have in column A are 73 and in column B with descriptions of products I have about 1800 products.
I like to insert automatically the anchor texts inside the description so I can upload the description back into the ecommerce for Search Engine optimization pourposes.
As an example I show Column A (Anchor Text/ Hyperlink) 100% Cotton.
In column B (Description) I found manually to 100% cotton without hyperlink. I am looking for some formula or function that allows me replace the words in column B with the words with hyperlink from column A.
Thank you for any advise, Rafael.
<style type="text/css"><!-- body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Liberation Sans"; font-size:x-small } --> </style>
<tbody>
[TD="align: left"]Anchor[/TD]
[TD="align: left"]Description[/TD]
[TD="align: left"] 100% cotton [/TD]
[TD="align: left"]3-ounce 60/40 cotton/polyGently contoured silhouetteOpen collar with ruffled Y-shaped slim placketFront and back darts3/4 sleeves with cuffsPearlized smoke buttons pearlized white buttons on Chambray Blue and Pink Orchid[/TD]
[TD="align: left"]Woven Shirts[/TD]
[TD="align: left"]4-ounce 100% polyester interlock Wicks and dries quickly 50+ UPF rating Tag-free label Narrow ribbed collar Double-needle coverseamed neck Double-needle sleeves and hem[/TD]
[TD="align: left"]T-Shirts[/TD]
[TD="align: left"]4-ounce 100% polyester interlock Wicks and dries quickly 50+ UPF rating Tag-free label Narrow ribbed collar Double-needle coverseamed neck Double-needle sleeves and hem[/TD]
[TD="align: left"]Accessories[/TD]
[TD="align: left"]4.5-ounce 100% cotton Deluxe 30-singles Softstyle yarns Junior contoured silhouette with side seam Feminine double-needle 1/2 rib knit seamless collar Double-needle sleeves and hemSports Grey 90/10 cotton/poly.[/TD]
[TD="align: left"]Activewear[/TD]
[TD="align: left"]4.5-ounce 100% cotton Deluxe 30-singles Softstyle yarns Seamless double-needle 3/4 neck Taped neck and shoulders Rolled forward shoulders for better fit Double-needle sleeves and hem Antique Heliconia Antique Sapphire and Sports Grey 90/10 cotton/poly.Dark Heather Heather Irish Green Heather Military Green Heather Navy Heather Orange Heather Purple and Heather Royal 35/65 cotton/poly.[/TD]
[TD="align: left"]Outerwear[/TD]
[TD="align: left"]4.5-ounce 100% polyester AquaFX moisture wicking Freshcare anti-odor properties Heat transfer label Rib knit 1/2 non-topstitched collar Side seamed with tapered fit Double-needle sleeves and hem Safety Green is compliant with ANSI/ISEA 107 high visibility standards for background color[/TD]
[TD="align: left"]Bags[/TD]
[TD="align: left"]4.5-ounce 100% polyester AquaFX moisture wicking Freshcare anti-odor properties Heat transfer label Rib knit 3/4 non-topstitched collar Double-needle sleeves and hem Safety Green is compliant with ANSI/ISEA 107 high visibility standards for background color[/TD]
</tbody>
