Thread: Making Everything Capital Letters In A Column: How ?
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.newusers
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Making Everything Capital Letters In A Column: How ?
=UPPER(A1)

Copy as far as needed.


"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