View Single Post
 
Old 02-10-2011, 10:20 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit 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, 20 views)
Reply With Quote