Flash Fill and Smart Formula
These features allow you to quickly extract desired part of the string from a column containing text, such as extracting numbers from mixed text and numbers. It can also be used to combine contents from multiple columns into the output column.
Watch on
