If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SD03*10 -how do I just get the numbers at the end in cell after *
,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! |
#2
|
|||
|
|||
SD03*10 -how do I just get the numbers at the end in cell after *
On Wed, 12 May 2010 12:43:01 -0700, Helen Maguire Helen
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 |
#3
|
|||
|
|||
SD03*10 -how do I just get the numbers at the end in cell after *
=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! |
#4
|
|||
|
|||
SD03*10 -how do I just get the numbers at the end in cell after *
"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 |
#5
|
|||
|
|||
SD03*10 -how do I just get the numbers at the end in cell after *
You can make it less complicated by using the RIGHT function instead of MID
(see my earlier suggestion). -- David Biddulph "HpyTrvlr69" wrote in message ... 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! |
#6
|
|||
|
|||
SD03*10 -how do I just get the numbers at the end in cell after *
Data Text to columns should work well...
Delimited Other * Finish HTH Regrds, Howard "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! |
Thread Tools | |
Display Modes | |
|
|