View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fastblogs
 
Posts: n/a
Default How To Remove all caps in column?


In My spread sheet I have a list of
names but they are all in caps...

That was great for an envelope but
not so good when I am going to
do a letter merge.

How do you remove or format the
names so they are not all caps?

Can you do that?

Obviously I would still need the first letter
to be capitalized but not the whole name.

Any help would be greatly appreciated, I am stuck
and do not want to type out every name ..

I have excel 2002 and access 2002 and I cant seem
to find out how to change this

Sam


--
fastblogs
------------------------------------------------------------------------
fastblogs's Profile: http://www.excelforum.com/member.php...o&userid=35118
View this thread: http://www.excelforum.com/showthread...hreadid=548727