Thread
:
SD03*10 -how do I just get the numbers at the end in cell after *
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
external usenet poster
Posts: 5,651
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
Reply With Quote
Ron Rosenfeld
View Public Profile
Find all posts by Ron Rosenfeld