Jim,

Can I bother you with one more question? The spreadsheet list of part
numbers contains a hyphen within the part number (example 0012-3323). The
jpg photos that the spreadhseet will search for do not have hyphens in their
corresponding part numbers. Is there a formula that can take the hyphen out
of the spreadsheet list of part numbers?

"Jim Cone" wrote:

If your data starts in B5, then in C5 use this formula...
= B5 & ".jpg"
Fill down
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"CompuSoft"

wrote in message
Is there a way to add a .jpg extension to a list of variable part numbers in
one column of an Excel spreadsheet?