Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-10-2011, 09:04 AM
aleale97 aleale97 is offline Extract numbers from a text string Windows XP Extract numbers from a text string Office 2010 32bit
Novice
Extract numbers from a text string
 
Join Date: Feb 2011
Posts: 3
aleale97 is on a distinguished road
Default Extract numbers from a text string


hi everyone.
I imported data from a web page, but they are not in a cell and a result I get something like this:
Last access9.2.2011
I want to extract(in this case) this number that it isn't only a date. Thx for any help

Last edited by aleale97; 02-10-2011 at 10:34 AM. Reason: Risolta
Reply With Quote
  #2  
Old 02-10-2011, 09:31 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Extract numbers from a text string Windows 7 32bit Extract numbers from a text string Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Welcome to the forum.

If that string is in cell A1 and assuming the number always comes at the end, you could use this formula to extract it:
Code:
=RIGHT(A1,1+LEN(A1)-MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")))
Gives this result:
Code:
9.2.2011
Reply With Quote
  #3  
Old 02-10-2011, 10:15 AM
aleale97 aleale97 is offline Extract numbers from a text string Windows XP Extract numbers from a text string Office 2010 32bit
Novice
Extract numbers from a text string
 
Join Date: Feb 2011
Posts: 3
aleale97 is on a distinguished road
Default

I've do a snapshop couse this string give me a error. I don't understand and i ask you if you can replace the random number with the number in this table. THX FOR THE HELP
Attached Images
File Type: jpg Immagine.JPG (25.6 KB, 14 views)
Reply With Quote
  #4  
Old 02-10-2011, 10:20 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Extract numbers from a text string Windows 7 32bit Extract numbers from a text string Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi,
Quote:
don't understand and i ask you if you can replace the random number with the number in this table.
Replace what number with what exactly?

I don't think I understand your question.
I thought you wanted to extract the part of the string at the end of each cell where there is a number, hence the solution I posted. I have attached an example of that (using your screenshot data) because it does what I think it should.

If this isn't what you need then please clarify so I can try to help further.
Attached Files
File Type: xls book3.xls (21.5 KB, 18 views)
Reply With Quote
  #5  
Old 02-10-2011, 10:33 AM
aleale97 aleale97 is offline Extract numbers from a text string Windows XP Extract numbers from a text string Office 2010 32bit
Novice
Extract numbers from a text string
 
Join Date: Feb 2011
Posts: 3
aleale97 is on a distinguished road
Default

Thx for the help i don't change a number in the string that you have posted. It works.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
inserting a string of data into an MS Word table??? matto Word VBA 0 07-16-2010 09:35 AM
Text and page numbers in footers? MikeT1953 Word 0 07-09-2010 08:14 PM
Add text to page numbers alpruett Word 0 07-07-2010 09:40 AM
Extract numbers from a text 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 08:44 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