Remove a* from cells

[MARK858]

Hi there, I have some cells that are from an imported text file which have a set of numbers but occasionally they have a * next to the number.
Is there a way of removing the 8 without affecting the values?
Obviously the numbers without the * are right aligned and the numbers with a * are left aligned. A sample is below

46320
45599
8270
41116
46306
46308
42606
43878*
41536
3276
45776
3670
47583

Any suggestions to try please

 

[meldoc]

Hello

Use Find and Replace.

Find:= ~*

Replace:= leave blank

 

[dmash]

Assuming your data starts in cell A1 and that the asterisk shows up only as the very last character.

=if(iserror(search("*",a1)),a1,value(left(a1,search("*",a1)-1)))

 

[MARK858]

Cheers Brian, how stupid am I. Needed a squiggle in front. Thanks again
Thanks to dmash as well for the formula