If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Running auto correct on startup?
Hi,
I'm using excel 2003 and I'm looking for a way to manually or automatically run auto correct on startup or after pasting. The thing is that I'm importing large amounts of data and using text to columns to sort it out and everythings fine, but the data comes from different places and does not always match very well. Since it's important that for instance "St. Peters" from one source and "Saint Peter's" from another source can automatically be changed to the same "Saint Peter's" I'm looking for something with auto correct here. As of now I'm searching through the data for matches to change them manually the one and the same. The only thing it would take was if there was a way to initiate auto correct manually on pasted data, cause then i could just take a day and add all the changes to auto correct and then it would do the job for me. Oh, i'm constantly overwriting old data with newer, pasting, so this is not a one-time operation, cause if it was i could live with it but I really need this. Thanks /Mitch |
#2
|
|||
|
|||
Running auto correct on startup?
Are you saying you've already added those corrections to your Autocorrect list?
If you haven't, I'd create another worksheet. Column A would hold the old (mistyped words) column B would hold the preferred words Then have a macro that would loop through those cells to do mass changes. Something like: Option Explicit Sub testme() Dim ListWks As Worksheet Dim WksToFix As Worksheet Dim myCell As Range Dim myRng As Range Set ListWks = ThisWorkbook.Worksheets("sheet1") Set WksToFix = ActiveSheet With ListWks Set myRng = .Range("a2", .Cells(.Rows.Count, "A").End(xlUp)) End With For Each myCell In myRng.Cells WksToFix.Cells.Replace what:=myCell.Value, _ replacement:=myCell.Offset(0, 1).Value, _ searchorder:=xlByRows, MatchCase:=xlYes Next myCell End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Mitch wrote: Hi, I'm using excel 2003 and I'm looking for a way to manually or automatically run auto correct on startup or after pasting. The thing is that I'm importing large amounts of data and using text to columns to sort it out and everythings fine, but the data comes from different places and does not always match very well. Since it's important that for instance "St. Peters" from one source and "Saint Peter's" from another source can automatically be changed to the same "Saint Peter's" I'm looking for something with auto correct here. As of now I'm searching through the data for matches to change them manually the one and the same. The only thing it would take was if there was a way to initiate auto correct manually on pasted data, cause then i could just take a day and add all the changes to auto correct and then it would do the job for me. Oh, i'm constantly overwriting old data with newer, pasting, so this is not a one-time operation, cause if it was i could live with it but I really need this. Thanks /Mitch -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I share my auto correct file with other users? | kasbury | Worksheet Functions | 2 | October 12th, 2005 07:25 PM |
Auto Correct Problem | Matt | General Discussion | 2 | December 17th, 2004 06:29 PM |
auto correct using an accent | Gisele | General Discussion | 4 | October 24th, 2004 01:37 PM |
How do I save Auto Text and auto correct entries when upgrading m. | Gabby V | General Discussion | 1 | October 20th, 2004 03:43 PM |
auto correct arrow isn't working although all options are enalbed | adi | General Discussion | 1 | October 4th, 2004 02:33 PM |