Help with Excel Deliminator

[Discover117p]

Hi All,

This is my first time on this and this forum seems very helpful from the other post i've seen.

I am working on a large set of data. Each row contains a column with cells such as below
*** DD-MM-YYYY (ZZ) ***
Random text sajfoadfoasdkdasn fddnvadnv dfkbaf
*** DD-MM-YYYY (ZZ) ***
Random Textfhdsfl asif 9guhasddf9 hdd
osdahfhadsfihisaf8af

The ZZ is the initials of a user so that varies like the date, SO E.G. john smith would be (JS)
I want to split this data up into columns when it finds *** DD-MM-YYYY (ZZ) *** it pull that and the text that follows.

I think i will need vba on this any suggestions kind people?

 

[Peter_SSs]

Welcome to the MrExcel board!

Could you post a few more examples and include the expected results with XL2BB so we can see exactly what is in each cell and can copy for testing?

 

[Discover117p]

Hi Peter,

Thank you for coming back to me so quickly =)

I work in a company that doesn't allow the extra add-ins to play around with stuff like this.. however here is couple of example


Column A1

*** 10-01-2019 (JS) ***
I have just checked the post box and there
is nothing new in there.

*** 11-01-2019 (AP) ***
Just checked Post box and we have received
a new letter which might be from
the government

Column A	Column B (result)	Column C (result)
*** 10-01-2019 (JS) *** I have just checked the post box and there is nothing new in there. *** 11-01-2019 (AP) *** Just checked Post box and we have received a new letter which might be from the government	*** 10-01-2019 (JS) *** I have just checked the post box and there is nothing new in there.	*** 11-01-2019 (AP) *** Just checked Post box and we have received a new letter which might be from the government

Hope that helps my friend.

 

[Peter_SSs]

Hope that helps my friend.

A little, but it doesn't really cover ..

a few more examples

Of course you are very familiar with your data and any variations, but we are not. Both your examples would be split into two columns but with so few examples it is hard to know if all your data will be split into two columns or whether some might be 3, 5, 12 or only 1 column. The technique may possibly vary depending on that.

In your 2 examples everybody has exactly 2 initials in the parentheses. Do they all, or might some have 3 or some other number?

Is there always a blank line in the cell between the sections as in your post #3 example or could there be none like in your post #1 example? (or more than one blank line?)

These are the sorts of things that might be clarified with a few more samples that show any variety in the data/results.