View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mrsethbullock@gmail.com is offline
external usenet poster
 
Posts: 6
Default Setting up capitalization after hyphens

Hi all:

I have a spreadsheet which lists 20,000 last names - all in lower
case. Some of these last names are hyphenated -- "smith-jones".

I would like to automatically capitalize the first letter and the
letter after the hyphen.

I can do the former using ASAP Utilities (a great plug-in!) but
haven't a clue as to how I capitalize the first letter after the
hyphen.

Any ideas on what to do?


Thanks,
SB