Excellent. Thanks Jim. This did the trick.

"Jim Cone" wrote:


From the Excel help file...
= SUBSTITUTE(text, old_text, new_text, instance_num)

This should do it...
= Substitute(AJ1,"-","")
(note that instance_num is optional)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(excel add-ins: sort, compare, unique, match, thesaurus...)


"CompuSoft"

wrote in message
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?