Search results

Hui, excellent Many thanks. trully a massive time saver. It works really welll thanks the only issue i have now is that the concat is over flowing the ammount of data that can be put into the cell, but thats okay as it flags that something else is wrong in the data.... but thats not my...

Hi old chippy, thanks for the trim function, I am currently working with it. but to answer your question, I have only on coloum of data but its rather long...... thanks for your help D9H

Hi Hui, Many thanks for the UDF 'concat" it does really work very well. however is it possible to put in a referance from another cell into the range so that the concat range is selected from a set of vairable values. sorry to be a pain. thanks D9H

I am trying to concatenate lots (100's of rows) of information together and will need to select the rows via a vlookup. I will need to do lots of these conatenates and each one will have a different starting and ending cell. I am trying to enter the cell address in concatenate function with...