Extracting numbers from a set of numbers in a column<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />Let say you have the following data table with 6 digits numbers in one column (Number 1) and you are interested in extracting only 4 numbers from those 6 numbers into a new column (Derived Numbers). How do you go about doing that? Thanks in advance.
| Number 1 | Derived Numbers |
|---|
| 201409 | |
| 201589 | |
| 201378 | |
| 201411 | |
| 201091 | |
Re: Extracting numbers from a set of numbers in a columnThe screenshot is actually a screenshot from one of data tables, which I was working with yesterday. For this specific example your formula would rather be:
Left(Number 1, 4)
Re: Extracting numbers from a set of numbers in a columnThanks, I figured it out Here is screenshot. I used the Left from the Character function group and selected the number of numbers that I want to extract from the original table.
