Removing a leading space in VB script

Hi all,

I have a single column of data in which every cell is preceded by a space. I need to get rid of the space before the data can be properly handled by the rest of my scripts and counted correctly.

I can do this already within Excel using this line below in each cell's adjacent cell -

Please Login or Register  to view this content.

Trouble is, this looks really messy, since it requires having two columns featuring basically the same data, albeit column A with the original data (eg. " 1234") and column B with the presentable data (eg. "1234", no space).

What I'd like to do would be run a line of code that does the same preceding space-removing magic as the IF command above, but do it within the macro rather than within cells on the page.

If anyone can suggest anything, it'd be very much appreciated.

Sorry if this is a double-post. I think IE (I know...) ate the previous one.

Anyways, thanks for that, Mike. It works, but not quite as I need it to. The problem is, it's removing the leading space from a text cell fine, but it ignores cells that only have a number in them. So, " Module" becomes "Module", but " 3" remains as " 3", where I need it to become "3". Any suggestions there?

Try

Please Login or Register  to view this content.

Thanks guys. I'll let you know how it goes when I get home.