AUSP Policy ID: 320764 Eff: 29/09/2021 Martin Ayles 63 Pty Ltd [10 Jan 2022] [Daniel Joiner WA] Status changed to Complete [11 Jan 2022] [Jo Atwell] am trying to split the above date and I want the date and the name in a new column - the data could exist of more than just 2 dates and names it could be 20 or 10 or just 1 but I just want to be able to split out based on any data in between the [ ] into its own seperate column as per below is there a formula that would work nicely for this ? appreciate your help cheers karyn |