Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.



Windows 7: Microsoft Office 2007 Excel Find and Replace Command

07 Jun 2013   #1

Windows 7 Ultiimate x64 bit
 
 
Microsoft Office 2007 Excel Find and Replace Command

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!

My System SpecsSystem Spec
.

11 Jun 2013   #2

Linux Mint 16 Cinnamon | Win 7 Ult x64
 
 

Might this be what you are looking for ...

[SOLVED] adding text to end of all cells in column
My System SpecsSystem Spec
11 Jun 2013   #3

Microsoft Community Contributor Award Recipient

Windows 7 Ult. x64 Windows 8.1 x64 Ubuntu 12.04 LTS Tri-Boot
 
 

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


Reply

 Microsoft Office 2007 Excel Find and Replace Command





Thread Tools




Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 09:37 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33