CONCATENATE cant use long text strings

[picky]

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

 

[GlennUK]

I have to ask ... are you sure Excel is the right application to use for this? What is the entire process that you are trying to achieve exactly?

 

[picky]

I only have to do this once, I will then save it as a comma seperated values file and upload to a database. If there is an easy way of doing this in excel then I would prefer to use excel. The end result is all the product descriptions having the hyperlink attached, in the same cell.

 

[Joe Was]

It should all be there, but the cell will not display all of it each cell has a display limit. The limit changes a little depending on its size and formatting. In memory it all should be there. For large strings you would use a text box. Your problem though is the hyperlink which will not work from the text box. Nor will it work from the tail end of a long string. You do have the option of converting the entire string into the hyperlink, but the cell will still not display the whole string.

What I have done to solve this problem is to use two cells one for the product name, which becomes the Hyperlink and the product description. When the product Into. is selected a text box on a user form opens and displays all the product info.

 

[picky]

Thanks joe! copied the cell contents into notepad and all the missing data appeared... many thanks.