Thread: Capitalizing text from the left limited by a comma
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max Prophet Max Prophet is offline
external usenet poster
  
Posts: 4
Default Capitalizing text from the left limited by a comma
How do I format a cell such that text left of a comma is capitalized?

example, the text in A1, "Rogers, Will", should be "ROGERS, Will"

thanks in advance
Reply With QuoteReply With Quote