In the earlier videos I have shared the ways to extract text through Right Function and Left Function.
In this video I will show you How you can use the extract function to transform the current column and clean up the data as per your requirement.