View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Curious[_6_] Curious[_6_] is offline
external usenet poster
 
Posts: 22
Default Odds need period, evens need semicolon

A long list of names looks like
Tiger
Cat
Dog
Goose

I want to add a period after Tiger, Dog, and add a semicolon after Cat
and Goose.

What is the feasible approach? Loop will not work, right? How about
array? Can you give me a few lines of codes?

Thanks a lot!

H.Z.