| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add multiple numbers in one cell with those numbers remaining visi | Excel Worksheet Functions | |||
| Selecting specific numbers from a cell containing multiple numbers | Excel Worksheet Functions | |||
| how to extract numbers from imported cell with text and numbers? | Excel Discussion (Misc queries) | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Hybrid Mode
