add .jpg extension to list of variable part numbers
 

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

add .jpg extension to list of variable part numbers
 

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?

add .jpg extension to list of variable part numbers
 

Thanks Jim.

I may not have asked my question correctly; however, with a slight variation
to your answer it did work. I had a list of more than 1000 different part
numbers that needed the .jpg extension added. The old list began in column B
at B1. The new list whitch needed the extension was going into column AJ. I
went to AJ1 and enetered =B1 & ".jpg". I then copied the AJ1 formula and
filled down in column AJ. The result was a new list of the same part numbers
in column AJ with the jpg extension added.

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

add .jpg extension to list of variable part numbers
 

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?

add .jpg extension to list of variable part numbers
 

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?

add .jpg extension to list of variable part numbers
 

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?