Hi, Try Text to Column Using Delimiter of ","Comma....
*Best Regards,* *Venkat * *Chennai* On Sat, Aug 6, 2011 at 6:49 PM, N Pradhan <nalini.pradha...@gmail.com>wrote: > sorry, comma is always available, but there may or may not be a 'space' > before mother's name. > > I would like to know whether this is possible with a formula. > > Name of Family Members Relation Mother's Name > HAUSHILA PRASAD DUBEY, SABITA DEVI FATHER, MOTHER > SHAKEEL AKTHAR, NAAJ PERVI, KAMAR JALAL FATHER,MOTHER,BROTHER > ABDUL MAJID, NAAJ FATMA, MARRIAM FATHER,WIFE, DAUGHTER > NARENDRA KUMAR SAHOO, JAYANTI SAHOO FATHER, MOTHER > KARMULLA BOX,RUKUM NISHA, JAMILA BANU, CHAND MOHMD FATHER, MOTHER, > WIFE, SON > PHULIN KISSHKU, CHAND MUNNI MOTHER,SISTER > DOS MOHAMMAD, HANIFIA, TAHABUMISSA FATHER, MOTHER, WIFE > > > Thanks & Regards. > > > ----- Original Message ----- From: "Rajan_Verma" <rajanverma1...@gmail.com > > > > To: <excel-macros@googlegroups.com**> > Sent: Saturday, August 06, 2011 6:01 PM > Subject: RE: $$Excel-Macros$$ Extract only mother names > > > > See if it Helps: >> >> Function ExtractName(Rng As Range, rng2 As Range) As String >> Dim M_Loc() As String >> Dim N_Loc() As String >> >> M_Loc = Split(Rng, ",") >> N_Loc = Split(rng2, ",") >> For i = LBound(M_Loc) To UBound(M_Loc) >> If Trim(M_Loc(i)) = "MOTHER" Then >> ExtractName = Trim(N_Loc(i)) >> Exit Function >> End If >> >> Next >> >> End Function >> -----Original Message----- >> From: excel-macros@googlegroups.com [mailto:excel-macros@** >> googlegroups.com <excel-macros@googlegroups.com>] >> On Behalf Of N Pradhan >> Sent: Saturday, August 06, 2011 5:28 PM >> To: excel-macros@googlegroups.com >> Subject: $$Excel-Macros$$ Extract only mother names >> >> I want a formula to extract only mother names as per attached sheet. >> >> Please help. >> >> -- >> ------------------------------**------------------------------** >> ---------------- >> ------ >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/**exceldailytip <http://twitter.com/exceldailytip> 2. >> Join our LinkedIN group @ >> http://www.linkedin.com/**groups?gid=1871310<http://www.linkedin.com/groups?gid=1871310> >> 3. Excel tutorials at >> http://www.excel-macros.**blogspot.com<http://www.excel-macros.blogspot.com> >> 4. Learn VBA Macros at >> http://www.quickvba.blogspot.**com<http://www.quickvba.blogspot.com>5. Excel >> Tips and >> Tricks at >> http://exceldailytip.blogspot.**com<http://exceldailytip.blogspot.com> >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><>**<><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/**discussexcel<http://www.facebook.com/discussexcel> >> >> -- >> ------------------------------**------------------------------** >> ---------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/** >> exceldailytip <http://twitter.com/exceldailytip> >> 2. Join our LinkedIN group @ >> http://www.linkedin.com/**groups?gid=1871310<http://www.linkedin.com/groups?gid=1871310> >> 3. Excel tutorials at >> http://www.excel-macros.**blogspot.com<http://www.excel-macros.blogspot.com> >> 4. Learn VBA Macros at >> http://www.quickvba.blogspot.**com<http://www.quickvba.blogspot.com> >> 5. Excel Tips and Tricks at >> http://exceldailytip.blogspot.**com<http://exceldailytip.blogspot.com> >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><>**<><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/**discussexcel<http://www.facebook.com/discussexcel> >> >> > -- > ------------------------------**------------------------------** > ---------------------- > > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/** > exceldailytip <http://twitter.com/exceldailytip> > 2. Join our LinkedIN group @ > http://www.linkedin.com/**groups?gid=1871310<http://www.linkedin.com/groups?gid=1871310> > 3. Excel tutorials at > http://www.excel-macros.**blogspot.com<http://www.excel-macros.blogspot.com> > 4. Learn VBA Macros at > http://www.quickvba.blogspot.**com<http://www.quickvba.blogspot.com> > 5. Excel Tips and Tricks at > http://exceldailytip.blogspot.**com<http://exceldailytip.blogspot.com> > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><>**<><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/**discussexcel<http://www.facebook.com/discussexcel> > -- * * * * * * -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
