Macro for cutting text

Hi, Can someone write for me a macro that can cut the text to last "star"?

GRU14 *******8.175,76
LIS14 *******1.297,67
PAZ14 *******2.474,68
WRZ14 *******3.880,25
SIE14 *******6.872,30
LIP14 *******7.846,27
CZE14 *******3.164,02
MAJ14 *******1.960,11
KWI14 *********919,35
MAR14 *******1.414,14
LUT14 *******2.714,29
STY14 *********371,69

I wont it to look like that:

8.175,76
1.297,67
2.474,68
3.880,25
6.872,30
7.846,27
3.164,02
919,35
1.414,14
2.714,29
371,69

Thank you above.

Yes and that is the problem

It would be great if u can do at least something like that:

*******8.175,76
*******1.297,67
*******2.474,68
*******3.880,25
*******6.872,30
*******7.846,27
*******3.164,02
*******1.960,11
*********919,35
*******1.414,14
*******2.714,29
*********371,69

Data in A column, paste this demonstration to worksheet module :

PHP Code: 

Sub Demo()
    With Cells(1).CurrentRegion
        VA = .Value
    
        For R& = 1 To UBound(VA)
                  SP = Split(VA(R, 1), "*")
            VA(R, 1) = SP(UBound(SP))
        Next
        
        .Value = VA
    End With
End Sub 


Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !