Extract numbers from a text string

aleale97 · #1 02-10-2011, 09:04 AM

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

Colin Legg · #2 02-10-2011, 09:31 AM

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

aleale97 · #3 02-10-2011, 10:15 AM

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

Colin Legg · #4 02-10-2011, 10:20 AM

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.

aleale97 · #5 02-10-2011, 10:33 AM

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

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
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