How to extract only numbers from a STRING?

Learner7 · #1 04-19-2011, 02:10 AM

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.

Colin Legg · #2 04-19-2011, 02:43 AM

Hi,

If you can assume that the number will always come at the end, this formula will do it:

Code:

=TRIM(MID(A1,MIN(SEARCH({1,2,3,4,5,6,7,8,9,0},A1&"1235467890")),255))+0

Learner7 · #3 04-19-2011, 03:32 AM

Quote:

Originally Posted by Colin Legg

Hi,

If you can assume that the number will always come at the end, this formula will do it:

Code:

=TRIM(MID(A1,MIN(SEARCH({1,2,3,4,5,6,7,8,9,0},A1&"1235467890")),255))+0

Thanks a lot for your kind help. It is working fine.

Regards.

excelboy · #4 07-02-2013, 06:25 AM

hello, can you please help me with extracting numbers from alphanumeric

for example I have:
PANDA # 1 THALATHEEN STREET

PANDA # 2 MALAZ GULF BRIDGE# 03, JEDDAH, SARI STPANDA # 4 HARAPANDA # 5 BATHA

I just need numbers from it.

Thanks

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