Hi Tris - are they all exactly the same lenght?

"Tris" wrote:

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