SD03*10 -how do I just get the numbers at the end in cell after *
in [Functions]
|
From: Helen Maguire Helen on 12 May 2010 15:43 ,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!
From: Ron Rosenfeld on 12 May 2010 16:05 On Wed, 12 May 2010 12:43:01 -0700, Helen Maguire <Helen Maguire(a)discussions.microsoft.com> wrote: >,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! =MID(A1,FIND("*",A1)+1,255) 255 just needs to be some value that is at least as large as the length of your longest value to be retrieved. --ron
From: "David Biddulph" groups [at] on 12 May 2010 16:12 =RIGHT(A2,LEN(A2)-FIND("*",A2)) -- David Biddulph "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!
From: HpyTrvlr69 on 12 May 2010 16:39 "Helen Maguire" wrote: > ,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! You could place this formula to the direct right of the cell that you want to parse. "CELL" = the cell address to the left of the formula where the data is stored. =MID(CELL,FIND("*",CELL1)+1,LEN(CELL)-FIND("*",CELL,1)) Hope its not too complicated and that it helps. HpY :)
From: "David Biddulph" groups [at] on 12 May 2010 21:17
You can make it less complicated by using the RIGHT function instead of MID (see my earlier suggestion). -- David Biddulph "HpyTrvlr69" <HpyTrvlr69(a)discussions.microsoft.com> wrote in message news:CE8FAA56-3FD9-4EF4-AE2A-277D0DF9DAEA(a)microsoft.com... > > You could place this formula to the direct right of the cell that you want > to parse. "CELL" = the cell address to the left of the formula where the > data > is stored. > > =MID(CELL,FIND("*",CELL1)+1,LEN(CELL)-FIND("*",CELL,1)) > > Hope its not too complicated and that it helps. HpY :) > > "Helen Maguire" wrote: > >> ,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! |