Thread: Capitalizing first word only...
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Umlas
 
Posts: n/a
Default Capitalizing first word only...
=upper(left(a1,1))&lower(mid(a1,2,255))
Bob Umlas
Excel MVP


"jojojpinkerton" wrote in message
...
Is there a way to capitalize just the first word of a cell (like a
sentence
would be capitalized)?


Reply With QuoteReply With Quote