bilbo85
05-09-2017, 04:06 PM
Hi,
I have thousands of rows of data in one column that I am trying to concatenate but it is proving not possible with the concatenate function as there are too many rows. Do you have a macro that could concatenate the rows (each separated by a comma) and then return the value rather than the formula please?
I know how to do this in Word by replacing ^p with a comma but I need a macro in Excel if possible.
Thanks very much.
I have thousands of rows of data in one column that I am trying to concatenate but it is proving not possible with the concatenate function as there are too many rows. Do you have a macro that could concatenate the rows (each separated by a comma) and then return the value rather than the formula please?
I know how to do this in Word by replacing ^p with a comma but I need a macro in Excel if possible.
Thanks very much.