SD03*10 -how do I just get the numbers at the end in cell after *
in [Functions]
|
From: L. Howard Kittle on 12 May 2010 23:54 Data > Text to columns should work well... Delimited > Other > * > Finish HTH Regrds, Howard "Helen Maguire" <Helen Maguire(a)discussions.microsoft.com> wrote in message news:488D0989-68B1-49B2-B5F1-6891FAB4D808(a)microsoft.com... > ,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! |