Microsoft Office Forums - View Single Post - How to extract only numbers from a STRING?

Thread: How to extract only numbers from a STRING?

View Single Post

Old

04-19-2011, 02:10 AM

Learner7

Learner7 is offline

Learner7 uses Windows XP

Windows XP Learner7 uses Office 2007

Learner7 uses Office 2007

Office 2007

Advanced Beginner

The original poster

Join Date: May 2010

Posts: 51

Learner7 is on a distinguished road

Default

How to extract only numbers from a STRING?

Hi,

How can I extract the numbers from a string from a cell.

Example: I have the below data in Cell A1 and would like to extract only numbers in to Cell B1:

Data in Cell A1: Purchasing Document 7500840745

Result in CELL B1 shall be : 7500840745

Thanks.

Reply With Quote