Thread
:
Need formula to extract a numeric value from a free-format text
View Single Post
#
3
July 16th, 2009, 07:28 PM posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 6,167
Need formula to extract a numeric value from a free-format text
Always the same number??
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Eric_NY" wrote in message
...
I have a column containing text values like "User requested authority of
emergency ID for reason NHUSER23 Restore of object to library LEVEL2
under remedy 1074317. 06/04/09 17:46 QPGMR".
Some of the cells contain a 7-digit number and others don't. The 7-digit
number does not start at a fixed location in the text.
Is it possible to write a formula which looks for the 7-digit number, and
returns the number if present, and another value (such as 0 or
"*MISSING*")
if not?
I'm using Excel 2003.
Thanks.
Don Guillett
View Public Profile
View message headers
Find all posts by Don Guillett
Find all threads started by Don Guillett