removing numbers by value?

[Johnb42]

Hi. I have what I hope is an easy question. Let's say I have a series of numbers in cells in a row (or in a whole worksheet, for that matter), for instance, a typical cell might contain:

24, 1 2009

...and I only want to keep one type of number in that cell - like say a four-digit number (i.e. a year value like 2009 above) - and delete the rest. So that would be deleting every number in a range of 0-999, or alternately, every number where x<1000.

How can one do this?

Thanks.

 

[PeteABC123]

Do a text to columns, delimited separators are commas and spaces. Hope that helps. Filter to remove contents.
Pete

 

[ghrain22]

=mid(a1,search("200?",a1),4)

 

[ghrain22]

Do a text to columns, delimited separators are commas and spaces. Hope that helps. Filter to remove contents.
Pete

This is probably a safer and better solution if you have consistent data format.

 

[Johnb42]

I'm happy to go with what you guys are suggesting, Pete and Ghrain, if only I knew what "do a text to columns" meant (I'm assuming, once I know that, I can find where to specify delimited separators, and where the Filter feature is). I apologize for my crippling levels of Excel retardation.

 

[ghrain22]

I'm happy to go with what you guys are suggesting, Pete and Ghrain, if only I knew what "do a text to columns" meant (I'm assuming, once I know that, I can find where to specify delimited separators, and where the Filter feature is). I apologize for my crippling levels of Excel retardation.

Data Tab in the ribbon>Text To Columns> Select the Delimited Radio Button. The rest is fairly self explanatory.