Thread: Making Everything Capital Letters In A Column: How ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Making Everything Capital Letters In A Column: How ?
See

http://www.mvps.org/dmcritchie/excel/proper.htm#upper




In article ,
"Robert11" wrote:

Hello:

I have a long column with various text in the cells.
Both capital letters, and lower case. Some cells have both.

Would like to make everything CAPS in all the cells, hopefully in one shot.

How can I do this, please ?

Thanks,
Bob
Reply With QuoteReply With Quote