Hi Span,

See David McRitchie's TrimAll page at:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall


---
Regards,
Norman



"Span" wrote in message
...
I am trying to eliminate spacing for a upc in a cell. For a example:
0 11111 22222 3
011111222223

I have tried Clean, Trim, & Substitute.

Anyone have any answers or Ideas?

Thanks,