Replace data in a column w/consistent spelling

alexbrown61

New Member
Joined
Jul 10, 2010
Messages
13
I have a spreadsheet that comes to me monthly. One particular column "organization" always has the exact same mispellings in it. I need to correct the spellings before further proccessing. Here is an example of the column that I need to change:

Organization (This is the column name)
Federal Center
Federal Ctr
Operations Center
Operations Ctr

Request VBA code that will change the data in the column using a lookup table named "Org" to replace with the correct and consistent names of the organizations.

I have huge amounts of data and would like to use VBA. I'm using W7 and E2007.

Thanks in advance for you help.

Alex
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

gsbelbin

Active Member
Joined
Aug 29, 2008
Messages
336
It's not 100% clear what versions are wrong and which ones are right but I'll assume you want to them to read Federal Center and Operations Center. So all you want to do is replace any occurence of Ctr with Center. In that case forget about macros and use the Replace facility for the worksheet. I'm not sure what the options are Excel 2007 but in previous versions it would be Edit | Replace then in the "Find What" box put Ctr and in the "Replace With" box put Center. Then click Replace All.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,699
Messages
5,833,201
Members
430,196
Latest member
rez5656

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top