If you want to take part of the text (substring), contained in a cell and reuse
it elsewhere, you can extract part of the text.
Before you begin
It is recommended to remove unnecessary blank spaces from the text records and to make sure the cells have the same length before proceeding.
Procedure
Results
Tip: This transformation can
also be performed by using the Magic fill
function.