Thread: Automatically Change Text in Cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Automatically Change Text in Cell
Maybe try playing with Tools AutoCorrect Options?
Replace: B
With: Brazil
Click Add OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
" wrote:
Hi,

I am not sure but there maybe a really easy way to do this. If a user
enters "B" in cell A1 how could I automatically change the "B" to
"Brazil" for example?

I am looking to create a calendar so when the users enters "B" for a
given date "Brazil" will appear instead of "L".

Thanks,

Brett


Reply With QuoteReply With Quote