Excel – Want to extract the numbers from a Cell

Asked By doriswneil 50 points N/A Posted on - 07/17/2012

Hi everyone,

From string and from a cell how would I be able to extract the numbers? For instance: the data should be kept in Cell and I want to do the extraction of only number into the cell B1.

Cell A1 Data: Purchasing Document 7500840745

And Cell B1 Data: 7500840745

Thank you for your cooperation.

• Status: Open
• Question Views: 1341
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Geisha Nitta

Go To Solution

Best Answer

Best Answer

Answered By Geisha Nitta 0 points N/A #141016

Excel – Want to extract the numbers from a Cell

With reference to your question what you want is, extract only the number from a cell which includes both numbers and texts.

There is not a direct way for you to extract numbers from such kind of cells in Microsoft Excel. However, I can explain in a way that you can fulfill it.

I will explain it through an example.

We will just take data series as mentioned. Please see the image below.

First copy and paste the same data series to column B.

And select data series in column B and click on the text to column in data tab.

Now click on the “Delimited” and click “Next”.

Click on the “space” check box then click “Next” and “Finish”.

You can see the three words which were in column A are now in three separate columns (i.e. Column B, C, D).

Then delete column B, C then the numbers will be appeared in Column B as follows.

I believe this answer will be helpful to you.

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 07/22/2012
• Question Category: MS Excel

Answered By Anthew Staw 0 points N/A #141017

Excel – Want to extract the numbers from a Cell

I have read your post and I think what you’re asking is how to extract the numbers stored in cell A along with the text attached to it, right? Well I have the solution for that.

Just key-in ‘=RIGHT(A2,10)*1’ on your cell B1 then drag it down to where you’re comfortable and see that the numbers with text on cell A is converted to numbers again in cell B without the text.

Hope this helps.

About Anthew Staw

Questions
3

Answers
34

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/03/2012
• Question Category: MS Excel