Hi there, new to the forum, will try to be as specific as I can with my query:
I have a product database, each product has its own row, and details such as price and product name etc are the columns. One of the columns is "product description", and another column is a hyperlink with a small bit of html code, both columns contain unique data for each product. I am trying to add the hyperlink to the end of the description of each product using CONCATENATE, but the descriptions are sometimes a few thousand characters long and concatenate cuts off some of the description, without adding the hyperlink either. Is there another function I can use?
example of what I want the end result to be in a new column for each row:
product description text is here
Click here to buy
I have a product database, each product has its own row, and details such as price and product name etc are the columns. One of the columns is "product description", and another column is a hyperlink with a small bit of html code, both columns contain unique data for each product. I am trying to add the hyperlink to the end of the description of each product using CONCATENATE, but the descriptions are sometimes a few thousand characters long and concatenate cuts off some of the description, without adding the hyperlink either. Is there another function I can use?
example of what I want the end result to be in a new column for each row:
product description text is here
Click here to buy