I'm v. new to VB and am trying to upload text into a data base but without the spaces.

I could only come up with a very long winded way using Trim and some other functions. Is there a way to do this more simply?

The text is alpha numeric with % symbols etc. and is sent to me in a single cell in Excel.

Any help much appreciated

Davellll