splitting out data from 1 cell into multiple

OK - for starters, you cannot split stuff into merged cells, so you are going to need to rethink your proposed outpout. Merged cells are a big no-no - Satan's spawn.

There are still merged headers.

Please add the mock-up of your required output to the sample workbook. Thanks.

Thanks - I'll have a look soon.

Are the markers always FI, AN, L1, etc.?

If not, then we need more samples and you need to explain the logic to us.

No reply ...

So paste this into A10 and hit ENTER:

=LET(l,TEXTSPLIT(TEXTBEFORE("L1"&TEXTAFTER(B2,"L1"),"/",-1),",","/"),IFERROR(--l,l))

Does this work for the L numbers?

OK - good. Try this in A10:

Please Login or Register  to view this content.

And with headers:

Please Login or Register  to view this content.

Glad to have helped.

If you want me to explain, just shout ...

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Oops! It should be this (I got rg and fn the wrong way round):

Please Login or Register  to view this content.

In case there are multiple rows of data:

Please Login or Register  to view this content.

Will have a look - been gardening, and now waiting for a call, so may not be until tomorrow morning.

This will work as long as there are three rows generated per row of source data:

Please Login or Register  to view this content.

If not, then you will need to provude a slightly more extensive set of more realistic data. For future reference, supplying only one row of sample data is never a good idea.

If you want the dates to be real dates and not text, change this:

TEXT(y,"dd/mm/yyyy")

to this:

INT(y)

and format that column as Short Date using number formatting.

Quite unexpectedly, this also seems to work:

Please Login or Register  to view this content.

You're welcome!

I was pleased to discover that OFFSET worked unexpectedly, so I got something out of it, too.

PS That one should work if there are uneven rows.