Split text cell into various records for linked lookup formula

[Luca_Wessels]

Hello All,

I am trying to convert a concatenated text cell into various records, split by the semi-column.

Ideally, an automation would somehow split the cell contents so I can return the linked lookup value for both Optimisers, and Double Storey and their relevant costs in another lookup column.

Is there a way I can split the contents into separate records for the pricing data column?

[TheTimeSavingCo]

Hi @Luca_Wessels ,

Just to confirm, you’d like to end up with the following, is that right?

If so, if you split your text by a comma instead of a semi-colon, you can paste that text into the Pricing Data linked field and it would become separate records based on the comma split automatically