View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Get First Letter of each word

On Wed, 20 Feb 2008 11:14:45 -0800, "Jim Cone" wrote:

Ron,
Try my modified version of your code and see what you get.
~ 1.19 vs. 0.73
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


Jim,

I see what you are doing and didn't realize that would happen.

~ 1.19 vs. 0.73


I get 0.739 vs 0.44

So the Ucase is definitely slower.

Thanks for that.
--ron