View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default HOW TO REPLACE TEXT AUTOMATICALLY

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.