=RIGHT(A2,LEN(A2)-FIND("*",A2))
--
David Biddulph


"Helen Maguire" <Helen wrote in message
...
,I have SD03*10 in a cell and I want in a separate cell, just to have the
numbers after the *. Obviously with lots of data, the digits after the *
could be 1 to many characters so I cannot use the Left function.

Any help would be greatly appreciated so I don't waste any more time!