A2 contains Clay;Mug;Blue and A3 contains Glass;Jar;Clear. Column B already holds stock counts. Leave the original descriptions and stock available for the reconciliation.

Preview the split before choosing a destination

Select A2:A3 in Ulet and choose Data → Text to Columns → Split by Semicolon. Confirm the preview is two rows by three columns. Set the destination to D2 after checking that every cell in D2:F3 is empty, then choose Import.

A2 and A3 contain the joined descriptions while column B contains stock counts.

Illustrated starting layout with nearby data to preserve.

Check a preserved cell and the last result row

Verify A2 still contains the joined text, B2 has its original count and D3:F3 says Glass, Jar, Clear. If a source row has an extra delimiter or a missing field, inspect how it appears in the preview before importing the full range.

The split destination is D2:F3. The second row reads Glass, Jar and Clear.

Illustrated footprint check after import.

Related Microsoft Excel reference