If you want to use the numbers contained in a column, such as the postal code in an address, you may want to extract this numbers to a new column.
- Select the column from which you want to extract numbers.
- In the Functions panel, type Extract Number and click the result to execute the associated function.
The numbers contained in the selected column are extracted to a new column. If the numbers are written using metric prefixes, such as 1k instead of 1000, they will be extracted and written using the American standard.
Tip: This transformation can also be performed by using the Magic fill function.