Today Microsoft Excel is one of the most widely used programs in the world to create spreadsheets., for this purpose you can use this tool to have control over various processes requiring simple and complex calculations. This will allow you to save time when using functions or formulas to obtain the desired result.
This time we will talk about how extract numbers and data from an excel cell In a simple way, because you will see that there are different alternatives to carry out this work, but many of them involve a high level of work, using nested formulas and even VB programming development to get the result.
In various cases, companies that have catalogs need to separate the numbers from the letters and that is why most of them go to the tool that Excel provides us, but we only have to follow a few steps.
Find the starting position of the number
Find the length of the number
Using quick fill
To make using the quick fill function You must follow the following steps, not without first considering that the list of alphanumeric data you have must have a pattern, Otherwise this option unfortunately will not work and you will have to make use of resources such as programming in VB or generating nested functions to obtain the result:
- Considering you have a column with a list of alphanumeric data With certain patterns, you can place in the columns you want, but preferably near this, the column where you will extract the numerical data and the column of the data (Letters)
- Assuming that in the list or column the first The alphanumeric data you have are “ABCP123NUM”, you will have to manually type in the numeric data column the expression 123
- Now write the remaining expression in the characters of the data column (Letters), as an example, “ABCP NUM” O “ABCPNUM”. Note that both cases can be valid, despite this, will give the tool the way you need it to extract the data. In the first case you have separated into two groups by a space and in the second case you have the expression without spaces.
- Once you have done the above steps, should choose the expression you typed in the numeric data column along with the empty spaces corresponding to the expressions you want Excel to extract, In other words, assuming you have 300 alphanumeric data.
- After manually typing the first, you must select the first data written by you and in the same column the others 299 missing spaces.
- With the chosen rank, go to the Data Tools tab and tap on fast fill. The result will be the extraction of the numerical data in the empty cells, according to the pattern you gave to the first number drawn.
Characters at the beginning or end
Intermediate characters
Now to extract the Lyrics data you must do the same procedure as above, but considering that the working column will be the one corresponding to the data (Letters). In the same way select cell range including the first one where you manually typed the letters extracted from the first expression and click quick fill.
There are many advantages that you will have when using this Excel tool, but undoubtedly the most important will be the save timeWell, you will see that for tables with little data, using this feature won't make much of a difference.
Despite this, when you have a few hundred or hundreds of data to analyze, this procedure will be helpful, since maybe you save hours of work that you can take advantage of to carry out other activities.
On the other hand, you will have another important direct advantage and that is that you can avoid data transcription errors which are very common when you have to handle large amounts of data manually.
Final thoughts
In conclusion, it is essential that you have or have various tools to perform your tasks efficiently, This is why it will be good for you to know how to use the Extract function in Excel, since it will be a plugin to extract data needed from a list.
At the same time, you should know that some versions of Excel do not have the fast fill option enabled, for this you can consult the fast fill enable procedure on the official Microsoft web portal.
