I have some data that is exported from another application into Excel 2003.

Each record has information contained in columns A thru to V, but can take up many rows (the max number of which is not defined however normally no more the 10 to 15). Despite the fact that the number of rows from each record varies, the end of each record is denoted by the following text string in column A #~~~~~#

I need to concatenate the data in Column D for each record but can’t work out how to tell Excel how many rows to concatenate in a dynamic way

Any help would be appreciated

Ta