autocorrect

Shiny · Mar 20th, 2002, 10:41 AM

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 · Mar 20th, 2002, 11:05 AM

Go to "Tools" AutoCorrect

Mark W. · Mar 20th, 2002, 11:11 AM

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

Paul B · Mar 20th, 2002, 11:13 AM

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. · Mar 20th, 2002, 11:17 AM

Quote:

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 · Mar 20th, 2002, 11:19 AM

Mark, Thanks for the tip

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 10:41 AM	#1
Shiny New Member Join Date: Mar 2002 Posts: 1	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?

Mar 20th, 2002, 11:05 AM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Go to "Tools" AutoCorrect

Mar 20th, 2002, 11:11 AM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	See the Excel Help topic for "Correct spelling and typing errors as you type". Especially, note the last sentence of the Tip.

Mar 20th, 2002, 11:13 AM	#4
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	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

Mar 20th, 2002, 11:19 AM	#6
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	Mark, Thanks for the tip