A LOT easier may be EditReplace

what: space

with: nothing

Replace all.


Gord Dibben Excel MVP

On Mon, 19 Sep 2005 09:28:09 -0700, "David Billigmeier"
wrote:

A LOT easier formula is:
=SUBSTITUTE(A1," ","")