Hi,
I have an excel spreadsheet.CORRECT-DIVISION.JPG
One of the columns is Division. It has some values.
I need to find a value U& & Switzerland and then change all of them to UK & Switzerland.
How do I do it?
I have also attached a screenshot of my excel file.
Thanks.
Make a copy of your workbook and test on your copy.
1. Copy U& & Switzerland
2. Ctrl+F to open the find & replace utility
3. In the Find field, paste No. 1 above.
4. In the replace field paste UK & Switzerland
5. Click Replace All
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
Thanks for your response. I recorded a macro that worked successfully. Thanks.
If you want VBA and programming ...
Select column A and name it as rngDivision
Then tryObviously the debug.print can be removed.
Please Login or Register to view this content.
Last edited by Oppressed1; 05-17-2012 at 12:19 PM. Reason: Added last line
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks