Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove trailing spaces from multiple columns in Excel | Excel Worksheet Functions | |||
Removing spaces from columns | Excel Worksheet Functions | |||
Removing spaces in cells with data in it | Excel Discussion (Misc queries) | |||
how do I remove empty spaces trailing a text string? | Excel Worksheet Functions | |||
Removing trailing spaces from cells ? | Excel Worksheet Functions |