CONCATENATE cant use long text strings

picky

New Member
Joined
Sep 29, 2006
Messages
3
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
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
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

New Member
Joined
Sep 29, 2006
Messages
3
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

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539
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

New Member
Joined
Sep 29, 2006
Messages
3
Thanks joe! copied the cell contents into notepad and all the missing data appeared... many thanks.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,053
Messages
5,545,740
Members
410,703
Latest member
yaronjoseph
Top