Hey Leith -

Thanks for the warm welcome .

Here is an example of the delimited data:

Column A

data1;#data2;#data3;#data4

I wanted to break each value onto a separate row, and delete the ";#" symbols if possible.

Sorry for not including that in the sample, and thanks for your help!