Hi Tris - if they are not the same length but that there is always a space
before the last *

Assuming the number is in cell B10 put this in cell C10
=LEFT(B10,LEN(B10)-2)

In Cell D10 put =CONCATENATE(C10,"*") if you want the * back on again.

Copy these formula down the whole length of the 1000 cells

THEN - select and copy the cells in column D - put your cursor where you
want the new cells to be and right click - then select Paste Special and
choose Value.

Hope this helps --- Yours Dika
"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