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
in2tech

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
TanyaC

Linux Mint 17 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
Golden

Microsoft Community Contributor Award Recipient

Windows 7 Ult. x64
 
 

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





Similar help and support threads
Thread Forum
Error on saving MS Office Excel 2007 files to MS Office 2013
We have an upgrade on our computer units here in the company, my problem is when users save their 2007 excel files an error pops up, Errors were detected while saving "File Name". Microsoft maybe able to save the file by removing or repairing some features. To make the repairs in new file, click...
Microsoft Office
Excel 2007 (MS Office 2007 enterprise)
I recently formatted my HD and reinstalled MS Office Enterprise 2007, I last used MS Excel on the 08/06/2014 without a problem, today I go to use my Excel spreadsheet and for some weird reason it wants to roundup my cells. I have cleared the cells formatted the number but it still keeps on...
Microsoft Office
Excel 2010, find & replace
Hi guys, In my Excel 2010 workbook there is a cell with the value of "90" in type of number/general. When I go to find and replace dialog box and try to find the number "90" by typing it in Find what rectangle, then I want the program looks for it in formulas (look in: Formulas). But it shows...
Microsoft Office
Installing MS Office 2010 to replace Office 2007
I purcased MS OFiice 2010 Professional through the MS Home Use Program to replace MS Office 2007. I received the link and product key via e-mail; I've ordered the CD's but they won't arrive for another 2 weeks. Several posts indicated that I should uninstall the 2007 version, then install...
Microsoft Office
2010 Office Professional Plus to Replace 2007 Office Small Business
Good Evening Everyone, I have a few questions concerning the Installation of 2010 Office. I know that I have to uninstall Office 2007. I have no clue on how to save or where to save my documents from Office 2007. The documents consist of Word, Excel, Powerpoint and a few various folders. ...
Microsoft Office
How to replace microsoft office 2007 / with 2010
Microsoft Office 2010/ Replace Office 2007 http://cdn.sevenforums.com/images/smilies/biggrin.gifI have Windows 7 Home Premium 64 and Microsoft Office 2007 Small Business. I will be receiving Office 2010 Professional Plus. Do I have to uninstall Office 2007 Small Business or can I install Office...
Microsoft Office

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 19:29.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App