Extracting part of a text
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 Removing unnecessary blank spaces in text records and to make sure the cells have the same length before proceeding.
Procedure
Results
Information noteTip: This transformation can
also be performed by using the Automatically formatting data based on examples
function.