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
|