Results 1 to 4 of 4

Thread: selecting a part of text in a cell

  1. May 11th, 2006, 09:44 AM #1
    enis
    enis is offline

    Thread Starter
    Member
    Join Date
    Apr 2004
    Location
    Turkey, Eskisehir
    Posts
    37

    selecting a part of text in a cell

    hi,
    In a cell, we have a text which composed by two or three word like this:
    "Angelina Jolie"

    I want to write a code and to determine if this cell has a text of "Jolie"
    Is there a function that do this or how can I do ?
    Reply With Quote Reply With Quote
  2. May 11th, 2006, 09:55 AM #2
    DKenny
    DKenny is offline
    Frenzied Member DKenny's Avatar
    Join Date
    Sep 2005
    Location
    on the good ship oblivion..
    Posts
    1,171

    Re: selecting a part of text in a cell

    Welcome to the forums!

    Here's a formula that will achieve this using the native Excel function FIND

    Assuming that the cell you are checking is A1
    Code:
    =FIND("Jolie",A1,1)<>0
    Declan

    Don't forget to mark your Thread as resolved.
    Take a moment to rate posts that you think are helpful
    Reply With Quote Reply With Quote
  3. May 11th, 2006, 09:56 AM #3
    Webtest
    Webtest is offline
    Frenzied Member
    Join Date
    May 2004
    Location
    Carlisle, PA
    Posts
    1,045

    Re: selecting a part of text in a cell

    Lookup the "Find" function in Excel, or "InStr" in VBA (Visual Basic Editor).
    Blessings in abundance,
    All the Best,
    & ENJOY!

    Art . . . . Carlisle, PA . . USA
    Reply With Quote Reply With Quote
  4. May 11th, 2006, 09:57 AM #4
    DKenny
    DKenny is offline
    Frenzied Member DKenny's Avatar
    Join Date
    Sep 2005
    Location
    on the good ship oblivion..
    Posts
    1,171

    Re: selecting a part of text in a cell

    Beat you to it
    Declan

    Don't forget to mark your Thread as resolved.
    Take a moment to rate posts that you think are helpful
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width