autocorrect

[Shiny]

I would like to learn more about how to use the AutoCorrect feature in Excel. More specifically, I recieve data from a vendor where the products listed are abbreviated. I also receive a list of abbreviations. Can I utlize the AutoCorrect feature to automatically translate the abbreviations as the data is recieved in Excel?

 

[Brian from Maui]

Go to "Tools" AutoCorrect

 

[Mark W.]

See the Excel Help topic for "Correct spelling and typing errors as you type". Especially, note the last sentence of the Tip.

 

[Paul B]

I don’t think excel will auto correct text that is not typed into it, like if it is pasted into excel, you can see what's in, and add to the auto correct list by going to tools AutoCorrect

 

[Mark W.]

On 2002-03-20 10:13, Paul B wrote:
I don’t think excel will auto correct text that is not typed into it, like if it is pasted into excel, you can see what's in, and add to the auto correct list by going to tools AutoCorrect

True, but a simple macro could be written that "visits" each cell, activates the formula bar (F2) and moves on.

 

[Paul B]

Mark, Thanks for the tip