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
0
Mitch (67)
11/28/2005 2:51:13 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
309 Views

Similar Articles

[PageSpeed] 26

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
0
petersod (12004)
11/28/2005 6:38:05 PM
Reply:

Similar Artilces:

E2003 naming ranges correctly
Hi! Even though I named the ranges in my excel workbook, I cannot properly import excel contacts into Outlook. Not even when the excel data was originally exported from Outlook! In the import dialog box, the actions to be performed field 'doesn't show only 1 excel file to import, but al the column headers of the file as seperate items. I can only map custom fields per item. The result of such import is very strange. I found out converting the excel file first in an access db and than importing that access file in Outlook contacts, is an easy work around. But I get really sic...

how to run other application from ur program
dear friends, i m new to MFC ,but i want to open application like notepad using MFC . i want to send window messages like VK_LWIN VK_UP VK_UP and certain no of other messages to open any other application. how is it possible. Seems like you want a CreateProcess() function. Read about the parameters you provide for this program. You may also use a very simple function ShellExecute(), but it may not give you much flexibility like a control over the process you're creating. Here is an example of opening notepad.exe: ShellExecute(NULL, "open", "notepad.exe", GetPathName...

correct other module entries in gl (reclass a/p)
When in GL transaction entries it would be very helpful if you could reclass "correct" entries from other modules and retain drill back link(for example A/P). Thank You ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutio...

Protecting while still allowing macros to run
Hi, I have a spreadsheet with macros that update formulas in cells. Is there any way of protecting the worksheet while still allowing the user to run the macros. Hi Tammy, If you use VBA to turn on protection you can look in the help system for the arguments for Protect and you will find one called UserInterfaceOnly:=True which allows the macro to run in a protected workbook, but doesn't allow users to modify stuff manually. Cheers, Shane Devenshire "Tammy" <Tammy@discussions.microsoft.com> wrote in message news:1D21508D-2564-4AFB-AB73-98C7ABC27A7C@microsoft.com...

running macros in excel
Does anyone know if I can run a macro automatically when I open the spreadsheet ? thanks. Call the macro Auto_Open, or add your code to the Workbook_Open event. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "bobuk" <anonymous@discussions.microsoft.com> wrote in message news:fbb201c3f219$2e99ee50$a401280a@phx.gbl... > Does anyone know if I can run a macro automatically when I > open the spreadsheet ? thanks. ...

That's correct
Even in my own contacts folder, the distribution lists do not work. It doesn't underline the name of the list--therefore, it must not recognize it at all. Stockmoose16 wrote: > Even in my own contacts folder, the distribution lists do not work. It > doesn't underline the name of the list--therefore, it must not > recognize it at all. Have you tired recreating mail profile? -- If my message is helpful, please help me by registering at http://www.openoffice.org/servlets/Join and voting for the following issues: http://www.openoffice.org/issues/show_bug.cgi?id=24969 http://...

insert row when cell full, auto wrap
Hi there, I used this code in ver 2003 to insert a row and wrap text in a cell..BUT, it does not work in ver 2007. Any ideas? Much appreciated. Private Sub Worksheet_Change(ByVal Target As Range) Dim NewRwHt As Single Dim cWdth As Single, MrgeWdth As Single Dim c As Range, cc As Range Dim ma As Range With Target If .MergeCells And .WrapText Then Set c = Target.Cells(1, 1) cWdth = c.ColumnWidth Set ma = c.MergeArea For Each cc In ma.Cells MrgeWdth = MrgeWdth + cc.ColumnWidth Next Application.ScreenUpdating = False ma.MergeCells = False c.ColumnWidth = ...

Auto-Accept Agent event sink for Exchange Server 2003 help!
I have installed the Auot-Accept Agent, using the local system account as the service's account. I have edited the AutoAccept.config.xml file, leeaving only the "global" configuration information. I have run the RegisterMailbox.vbs and ListMailboxes.vbs scripts to add and list those accounts added (I created a text file with the default SMTP addresses as found in Exchange Server 2003). All of these steps appear to have gone off flawlessly... The problem... proving this is true with the MailboxStatus.vbs script. This script's XML output (run with the /DEBUG option on) indic...

ValidationType.Auto and reading schema attribute
Hi, I would like my default ValidationType to be Auto. Now let's say I have both a DTD and an XSD file for this XML file being validated. While it's ValidationType.Auto, it will validate the DTD, but will not even attempt to read/validate the namespace or even check if schema file exists. I suppose it's a resolver problem; anyone have any insight on how I can have it check the schema File while Auto (without setting ValidationType.Schema)? ..NET 1.1 Validation can not perform DTD and XSD validation at the same time. If you have ValidationType set to Auto, and have a DTD decl...

RE: Use these corrective pack
--azhqxuwxwhlhu Content-Type: multipart/related; boundary="gjdeozsipvnkzwueg"; type="multipart/alternative" --gjdeozsipvnkzwueg Content-Type: multipart/alternative; boundary="hvzmojeie" --hvzmojeie Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft User this is the latest version of security update, the "September 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now...

Running Rules in Special Folders (Outlook and CallPilot)
Software: Outlook 2000 SP-3 and CallPilot Desktop Messaging 2.50 Background: Incoming voice messages are placed in the Callpilot Desktop Messaging Inbox in Outlook. A small icon lights up to indicate that a new message has been received. Question: How can I use a Rule in Outlook to also play a sound in a special folder? So far I am unable to have a rule continuously checking this particular inbox. Thanks, Lee Outlook rules doesn't support that - you might be able to use VBA to alert you - see outlookcode.com if you need help with VBA. -- Diane Poremsky [MVP - Outlook] Author, Teac...

Unknown program running
I get the "critical Stop" sound periodically even when my computer is not being used. Sometimes when I go to click my user name after it has been idle it will say two programs running even if only one is open. Hitting Alt-Ctrl-Del shows either no applications running or only the one I have open never two. How do I find out what program is causing the "critical Stop" alarm? Dennis wrote: > I get the "critical Stop" sound periodically even when my computer > is not being used. Sometimes when I go to click my user name after > it has been idle it w...

vc++ 6.0 application runs on windows 20003 (64 bit CPU 32 bit OS)
Hi I have a VC++ 6.0 application runs on windows 20003 (64 bit CPU and 32 bit OS), it does not work. The same application runs fine on Windows XP and Windows 2000. When I debug it with VC++ 6.0, the break points and the source code totally messed up. I have a if else statement, the debug goes from inside if goes to else block if (...) { ....................... } else { ............... } Does any one have any idea about this? Thank you for your help There is no content whatsoever in the phrase "does not work". There is always a specific statement as to why something do...

running balance
Hi I need help figuring out a formula for a running balance. I have 3 columns one called deposits, another called petty cash disbursements and another called expenses. I want to be able to know how can I get the total amount of money that I have on an account even though I keep on entering different dollar amounts at all times. I know that the formula =A39-B39 is giving me the amount for the first two columns, but I don't know what to do for the third column. I would really appreciate it if someone can help me out. Thanks. Jackie deposits-disbursements-expenses+previous balance ...

domain controllers do not appear to be running #2
Hi There are a number of errors when running CRM 3.0 and I have the following error when I run the environment diagnostics check : "Some of the domain controllers do not appear to be running. The following list of servers should be checked. PrivUserGroup {8654dfe6-2d69-4ead-8f86-d49f26814c64} ReportingGroup {8654dfe6-2d69-4ead-8f86-d49f26814c64} SQLAccessGroup {8654dfe6-2d69-4ead-8f86-d49f26814c64} UserGroup {8654dfe6-2d69-4ead-8f86-d49f26814c64} " Does anyone have any suggestions ? If I re-run the setup do I risk losing any data/configuration setting on my current installatio...

All message envelopes closed on startup
Client-Outlook 2002 SP2, WinXP SP1, all latest updates. Exchange 2000 Server When Outlook starts up everytime, all the envelopes in the Inbox have closed envelopes but messages are not bold unless they are new messages. Once I either sleect another folder and come back to INbox or minimize Outlook and then restore it, the envelopes are displayed correctly. Any ideas as to why this occurs? ...

Auto-Hide and Always On Top Plug In or Code?
I have developed a small app I would like to have behave like the Windows XP Taskbar, in that users should be able to select either Auto- Hide or Always On Top, and get the same behavior you get with the Taskbar. Is this something I should be able to accomplish in code? When I first started this project months ago, I didn't think so, so I convinced my firm to purchase LogicNP's Shell Mega Pack Sorry, too fast the fingers. Anyway, there are a number of issues with the ShellAppBar tool that make it undependable, and LogicNP seems to no longer be supporting the product (or...

Moving the email addresses from Auto-Complete
This question is Windows Vista/Windows 7 and Outlook 2007 specific. I am about to upgrade a machine running Windows Vista to Windows 7. How do I migrate the email adresses from Auto-Complete to the new machine. I cannot find the *.NK2 file anywhere on this machine. The resposes always seem to reference Win XP or Outlook 2003. I need an aswer for my specific question. "John A" <John A@discussions.microsoft.com> wrote in message news:08F25A1C-B461-4A02-8562-3E491553CA07@microsoft.com... > This question is Windows Vista/Windows 7 and Outlook 2007 specific....

what is the difference between auto fill and custom fill
I do not think "custom fill" is a truly valid term. Autofill is the process that uses data in adjoining cells to determine the contents of cells. This can be based on Excel's internal rules or the contents of Custom Lists. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ ...

Auto Fill/Auto Lookup??
I have created a form to input new data into the database. The data table for the database is called "TAODailyLog". In this table the column headings are Date, Site ID, Buoy ID, WMO ID, and Deploy Date (there are others, but these are the important ones). I have another table called "siteid". This table I use primarily for looking up values. In the "siteid" table, the columns are Order, SiteID, pmID, wmoID, and juliandeployed. With each new record that is placed into the database, the user must put in the Site ID, Buoy ID, WMO ID and the Deploy Date. ...

Auto Function
Is there a way tin access if a certain field in a table is something that it will automatically fill something in another field. If a value within a table is 90 to 95 I would like it to fill in the value of 4 and if it is 96 to 100 to fill in a value of 5. Is there anyway for this to be accomplished. Thanks On Wed, 12 Mar 2008 17:45:01 -0700, Anthony wrote: > Is there a way tin access if a certain field in a table is something that it > will automatically fill something in another field. If a value within a > table is 90 to 95 I would like it to fill in the value of 4 and ...

econnect doesn't correctly update 1099 amounts
We just found out a very serious problem - the econnect integration program that we installed last yearis not correctly updating 1099 amounts for vendors who should be receiving 1099's. All of the vouchers that were posted via econnect show $0 for 1099 amounts. Has anyone else had this problem? (We are currently using Great Plains v8.0) ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow thi...

Identify month in a period and run a formula
I am having trouble with creating this one formula. Can anyone help? I have two columns of dates (start and finish dates). I would like to identify a month (e.g April)that occurs in the period between start and finish and then if the month of April does occur in the period, calculate the number of months between start and finish and divide by a constant (a figure saved on a different sheet). So far I have this: =IF(AND(("01/04/2005">=MIN(I20:I23,H20:H23)),"31/04/2005"<=MAX(I20:I23,H20:H23)),SUM((D18/((YEAR(I20:I23)-YEAR(H20:H23))*12+MONTH(I20:I23)-MONTH(H20:H2...

Email Signature: Not appearing correctly...
This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C45ACF.EC2AE220 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I am attempting to make an e-mail signature for my e-mails and it's not = doing exactly what I want it to do. I am currently using Outlook 2000. = (Incase you'll need to know that.) I have went into the e-mail signature section where you can edit your = signature. Well I hit a button called, "Advanced Edit". Then it opens = up my signature in Word. And I basically edit it ...

Run a macro to copy selective items
I receive daily several lists of part orders from the customer in Excel file that I do not have any control of. In the Excel file: Column A contents catergory 1 to 100 Column B contents items descriptions of each catergory (about 20 different items per catergory) Column C contents quantities of each item that are changed daily. How can I run a macro that will copy from the customer Excel file and paste only certain catergories within my department (i.g catergory 1 -20) and ignore the rests. Appreciate for any of your help Chris -- chrisdtran -------------------------------------------...