How to extract only numbers from a STRING?

		Microsoft Office Forums > Microsoft Excel > Excel
How to extract only numbers from a STRING?

FAQ

Thread Tools

Display Modes

04-19-2011, 02:10 AM

Learner7

Windows XP How to extract only numbers from a STRING?

Office 2007

Advanced Beginner

Join Date: May 2010

Posts: 51

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't See Attachments When E-mail String is Saved to PDF	wineattorney	Outlook	1	03-29-2011 02:15 AM
Extract numbers from a text string	aleale97	Excel	4	02-10-2011 10:33 AM
inserting a string of data into an MS Word table???	matto	Word VBA	0	07-16-2010 09:35 AM
Macro or Function to know wether a string is included in a text	Eduardo	Word VBA	5	06-15-2009 01:55 AM
Extract from String using Wildcard	whousedmy	Word	0	05-21-2009 01:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:56 PM.