Microsoft Office 2007 Excel Find and Replace Command

[in2tech]

I know I can do this as I have done it in the past a long time ago. Using the Find and Replace option add and extension to my sku numbers, such as:

SKU #

8686708052

I have a column of these sku's and want to add the extension .jpg to all of them at one time!

8686708052.jpg

I have done this in the past and can't remember what I did and it worked great instead of having to manually add the .jpg extension to every sku #!

Thanks!

 

[TanyaC]

Might this be what you are looking for ...

[SOLVED] adding text to end of all cells in column

 

[Golden]

Good one....I was going to suggest using the CONCATENATE function, but your find is simpler.