=substitute(A1," ","") and fill down, then copy the results, paste special
values onto the original.
Bob Umlas
Excel MVP

"Tris" wrote in message
ps.com...
Can anyone please help!!!!

I have excel files supplied to me

as they currently stand they are as

*12345678 *
*90123456 *

I need to get read of the space between the last number and the last
asterix

I have tried and failed for hours!!

Any one know the formula i can use without going through and deleting
each of the spaces by hand. I have over 10000 to do so it will take a
while.

Many Thanks

Tris