Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-19-2011, 02:10 AM
Learner7 Learner7 is offline How to extract only numbers from a STRING? Windows XP How to extract only numbers from a STRING? Office 2007
Advanced Beginner
How to extract only numbers from a STRING?
 
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
  #2  
Old 04-19-2011, 02:43 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline How to extract only numbers from a STRING? Windows 7 32bit How to extract only numbers from a STRING? Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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
Reply With Quote
  #3  
Old 04-19-2011, 03:32 AM
Learner7 Learner7 is offline How to extract only numbers from a STRING? Windows XP How to extract only numbers from a STRING? Office 2007
Advanced Beginner
How to extract only numbers from a STRING?
 
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default

Quote:
Originally Posted by Colin Legg View Post
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.
Reply With Quote
  #4  
Old 07-02-2013, 06:25 AM
excelboy excelboy is offline How to extract only numbers from a STRING? Windows 8 How to extract only numbers from a STRING? Office XP
Novice
 
Join Date: Jul 2013
Posts: 1
excelboy is on a distinguished road
Default Extract number from alphanumberic

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to extract only numbers from a STRING? 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
How to extract only numbers from a STRING? 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 07:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft