Can I take text from a dynamic range and concatenate into a single cell?

Hi there,

I am looking for a solution to perform the following task:

I have a spreasheet formatted like a form, which users insert data into. The data will be entered into one column but an undefined number of rows, as users will be able to create additional rows. i.e A1, A2, A3 . . . Ax

I know the start cell A1. The data will contain text only.

I then need to take this text data from multiple rows and concatenate it into a single cell and format it in the style of 1) <rowdata1> 2) <rowdata2> 3) etc..

I have managed to work the dynamic array as a sum(calculation) based on example from a book but can I do the same with text?

Hope someone can help!

Hi, This may help:-

Please Login or Register  to view this content.

Regards Mick