I should explain... my formula assume the UPC number is always located at
the end of the text.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
Give this formula a try...

=MID(A1,SEARCH("UPC",A1&"UPC"),99)

--
Rick (MVP - Excel)


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