IF and Right Functions
in [Functions]
|
Prev: Sum Function Visible Cells only
Next: Vlookup issue
From: Elaine on 22 Apr 2010 19:34 Mike, Jim, RagDyeR, and John, All of you are GREAT! I thank each and one of you for your input. I'm so glad I have "background" support. Again, my many thanks for all of your efforts and continued support. Respectfully, Elaine "Bernard Liengme" wrote: > Thanks for comment. Not much work since in many cases I actually make a > workbook to ensure I have no typo errors in formulas > cheers > Bernard > > "John" <johnd(a)newlook.com> wrote in message > news:u$Sq#ZL4KHA.1624(a)TK2MSFTNGP06.phx.gbl... > > Hi Bernard > > To receive answers like that would be great, a treasure house to keep for > > reference. > > It would be much more work for you!!! > > Regards > > John > > "Bernard Liengme" <bliengme(a)TRUENORTH.stfx.ca> wrote in message > > news:uzha3UK4KHA.5212(a)TK2MSFTNGP04.phx.gbl... > >> Elaine, > >> I am trying a new way to reply to questions (where appropriate). > >> I have made a file that takes Mike's formula apart step-by-step starting > >> from the inside. > >> This will help you see how it works. > >> The file is housed at > >> http://cid-162119ff97286948.skydrive.live.com/self.aspx/.Public/TextExtract.xls > >> This is the Microsoft Skydrive locale where one can store private and > >> public files > >> Just copy the URL into your browser > >> I would be interested in your reaction to getting answers like this > >> best wishes > >> -- > >> Bernard Liengme > >> Microsoft Excel MVP > >> http://people.stfx.ca/bliengme > >> > >> "Elaine" <Elaine(a)discussions.microsoft.com> wrote in message > >> news:ED069296-CABA-4FA7-AABB-FF9E0BC25821(a)microsoft.com... > >>> WOW! Thank you for your quick response to my question. It works like a > >>> champ. > >>> Can you give me a break-down of the formula you gave? > >>> > >>> Thank you, thank you, thank you! > >>> > >>> Elaine > >>> > >>> "Mike H" wrote: > >>> > >>>> Hi, > >>>> > >>>> Try this for a string in a1 and drag down > >>>> > >>>> =MID(A1,FIND("^^",SUBSTITUTE(A1,"-","^^",LEN(""&A1)-LEN(SUBSTITUTE(A1,"-",""))))+1,1024) > >>>> -- > >>>> Mike > >>>> > >>>> When competing hypotheses are otherwise equal, adopt the hypothesis > >>>> that > >>>> introduces the fewest assumptions while still sufficiently answering > >>>> the > >>>> question. > >>>> > >>>> > >>>> "Elaine" wrote: > >>>> > >>>> > Hello, > >>>> > > >>>> > I have part #'s that end in 3 or 4 characters, some with a space. I > >>>> > would > >>>> > like to display the last 3 or 4 characters in another column. I tried > >>>> > using > >>>> > the IF and Right functions and have not solved it. I thank you in > >>>> > advanced > >>>> > for your help on this formula. > >>>> > > >>>> > Example: > >>>> > Part # New Column (Result) > >>>> > 30-179-TC1 TC1 > >>>> > 30-181-T C2 T C2 > >>>> > 30-185-TC23 TC23 > >>>> > > > > . > |