View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Yuanhang Yuanhang is offline
external usenet poster
 
Posts: 28
Default HOW TO REPLACE TEXT AUTOMATICALLY

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.