View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Michael
 
Posts: n/a
Default How do i make every first letter caps?

Hi Nicole. Assuming you type your business names in Column A, say starting
with independent construction in A2, you could type in B2: =Proper(A2) and
it will convert A2 to Independent Construction. Copy B2 down as far as
needed and then Copy, Paste Special, Values. You could then delete column A.
HTH
--
Sincerely, Michael Colvin


"Nicole" wrote:

Im typing business names and want to know if there is a way to automaticly
make every first letter in caps