Please drop the CAPS. Very hard on the ears and difficult to read.

Autocorrect only works on newly entered text, not on existing text unless you go
to each cell and hit F2Enter

For existing text why not select all the cells then EditReplace

what: Company

with: Co.


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 09:28:00 -0800, Yuanhang
wrote:

THANK U VERY MUCH FOR SUCH A QUICK ANSWER. IT WORKS. HOWEVER, IT COULDN'T BE
REFRESHED UNTIL I CLICK ENTER AT EACH CELL. IS IT BECAUSE MY VERSION OF EXCEL
TOO OLD (EXCEL 2000)?
LET'S SAY, THERE IS A CELL SAYS, "ABC COMPANY". AND I WANT IT TO BE LIKE
"ABC CO." SO I INPUT "COMPANY" FOLLOWING "REPLACE" AND TYPE "CO." INTO THE
"WITH" FIELD AS WHAT U TOLD ME TO DO. THEN I CLICK "ADD" AND "OK".
BUT THE TEXT DOESN'T CHANGE ITSELF UNLESS I SELECT THAT CELL AND PRESS
SPACE. IN THIS CASE, THE AUTOCORRECT DOESN'T HELP A LOT. ANYWAY TO IMPROVE
IT? THANK YOU.

"Kevin B" wrote:

Click TOOLS in the menu and select AUTOCORRECT.

On the AUTOCORRECT tab in the REPLACE field, enter the word you want to
replace and in the WITH field the word or abbreviation you want to replace
the word with.

Click ADD

Repeat as many times as necessary.
--
Kevin Backmann


"Yuanhang" wrote:

AS THE TITLE SAYS, I WANNA REPLACE SOME LONG WORDS INTO SHORT ONES, LIKE
"COMPANY" TO "CO.", "LIMITED" TO "LTD.". I KNOW I CAN DO THIS ONE BY ONE
MANUALLY. HOWEVER, IS THERE ANYWAY THAT COULD DO THIS AUTOMATICALLY WHENEVER
I UPDATE MY DATA? THANK YOU.