Hello Ali,

Thank You very much for your response it is working absolutely fine. I have a small request if could you please help me understand the formula how it functions and if I want to make any changes like for e.g.: in Row 4 I want to extract these values in output required column. Basically the unique in every row.

LLC - Services, LLC - Digital, LLC Limited - (UK) - Services, LLC - Generation, LLC - Risk

Also another quick question is this formula specific to column B only? Suppose I have a similar data in column D and I need output in column E will it not work because when I copy paste the formula and change the range it is not working. The data is another cell is like

INSURANCE CO., LTD - VTS - VRM318491196 - 2023 - 2029340


Thanks,
Ritu Raj