Or, for JUST the number

=IF(ISERROR(SEARCH("upc",H5)),"",MID(H5,SEARCH("up c",H5)+4,FIND("
",H5,SEARCH("upc",H5)-1)))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message news:...
=IF(ISERROR(SEARCH("upc",H2)),"",MID(H2,SEARCH("up c",H2),FIND("
",H2,SEARCH("upc",H2)-1)))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"klafert" wrote in message
...
I was using the formula, which worked but I only want the UPC Code #
extracted not the whole column - thanks

"Don Guillett" wrote:

datafilterautofilterfilter on column desiredcustomcontainsupc
voila
or a looping macro using if INSTR
or a formula
=IF(ISERROR(SEARCH("upc",H2)),"",H2)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"klafert" wrote in message
...
I have a spreadsheet with 390 rows. In one column I have data such as
this:


6" MARGINATA UPC#200653

Some of the lines have UPC# and some don't. The ones that do I would
like
to extract out to another column. Thanks for any help!!!