Both methods work. While I would probably choose regex
myself, I know not everyone feels comfortable with them. They're
certainly not as intuitive as string functions. Use whichever you
feel most comfortable with. Though regex are very powerful and well
> One way is using string functions. Left() to grab the
first letter and
> UCase() to capitalize it. You can use Right() and Len()
to grab the rest of
> the word.
> You can see an example of something similar at
cflib.org. But read the usage
> on how it operates if you pass multiple words.