View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pgcn@westnet.com.au is offline
external usenet poster
 
Posts: 7
Default convert second word in range to Proper when first variable length- urgent please

I've replied to Rick about an hour ago but it doesn't seem to have
posted.
Apologies if this is a repeat.

Are there **always** initials in front of each name (single names and names
with & between them)?

Yes (1 or 2 with no spaces between)

Is there **ever** any other symbol joining compound
names besides & and dash?

No

Do any names have multiple initials with spaces

between them?
No

Any other type of anomalies that you are aware of?

None

Thanks very much
Peta