On Wed, 30 May 2007 08:35:02 -0700, klafert
wrote:

This worked for the most part, but for some reason there are some that it
gave me a error on the company name but gave me the bid # or some didnt give
me anything. The error is #VALUE!. I tried to look up the command but I
don't know what the function is called. Can you explain what the formula
means or ... I know while some didnt because they only had company names and
not the bid number but that is fine I can copy those over to the next
column!! But for the most part this worked great!!

Thanks Mary

The functions used are MID, LEFT and SEARCH. Their explanation can be found
under Excel HELP.

One cause for a VALUE error is if the input does not match the specifications
you gave in your original post.
--ron