View Single Post
  #31   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default how do i separate numbers and text in a cell?

A UDF might look more elegant, but they are usually relatively sluggish.
I'm not sure it could match that same performance level.


Ah, I see what you mean. The UDF I developed (maybe it could be made a
little more efficient, however it) took 19 seconds to process a 30,000 row
sample I created (as opposed to your under 2 second solution).

Rick