How to remove specific text in particular column in cell value

Hi @loveleet_Saini ,

Thank you for solution , i have another question that string space are longspace i couldn’t get name please help me this.

Sorrry to ask again

image

Regards,
Raja G