Consulting

Results 1 to 8 of 8

Thread: String with String

  1. 09-22-2010, 06:22 AM #1
    Chandrasheka
    Chandrasheka is offline
    VBAX Regular
    Joined
    Jul 2010
    Posts
    49
    Location

    String with String

    Hi,

    I to extract string within string. I have attached excel file please let me know how to do it using excel formula.

    Thanks
    Chandra Shekar
    Reply With Quote Reply With Quote
  2. 09-22-2010, 06:52 AM #2
    lynnnow
    lynnnow is offline
    VBAX Tutor lynnnow's Avatar
    Joined
    Jan 2005
    Location
    Mumbai, Maharashtra, India
    Posts
    299
    Location
    =MID(A2,SEARCH("of ",A2,1)+3,LEN(A2))
    Reply With Quote Reply With Quote
  3. 09-22-2010, 06:57 AM #3
    p45cal
    p45cal is offline
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    Chandrasheka, if you must cross post, please have the courtesy to tell others everywhere you have done so.
    So far:http://www.mrexcel.com/forum/showthread.php?t=496545
    …anywhere else?
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
    Reply With Quote Reply With Quote
  4. 09-22-2010, 07:09 AM #4
    Chandrasheka
    Chandrasheka is offline
    VBAX Regular
    Joined
    Jul 2010
    Posts
    49
    Location

    String within String

    Hi,

    I am not getting desired result again I am attaching file. Please do the needful.

    Thanks
    Reply With Quote Reply With Quote
  5. 09-22-2010, 06:01 PM #5
    Aussiebear
    Aussiebear is offline
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,064
    Location
    Quote Originally Posted by Chandrasheka
    Hi,

    I am not getting desired result again I am attaching file. Please do the needful.

    Thanks
    Do you understand what we mean by posting a link when you have the need to cross post?
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link
    Reply With Quote Reply With Quote
  6. 09-23-2010, 12:37 AM #6
    Chandrasheka
    Chandrasheka is offline
    VBAX Regular
    Joined
    Jul 2010
    Posts
    49
    Location

    String within String

    Hi,I am new to excel please let me know what it is.ThanksChandra Shekar
    Reply With Quote Reply With Quote
  7. 09-23-2010, 12:42 AM #7
    GTO
    GTO is offline
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,368
    Location
    Greetings Chandrasheka,

    Cross-posting is when you post the same problem in different forums. I think that this is an awfully nice explanation--->Here

    If you have any questions after clicking on the link and reading the article, please do not hesitate to ask :-)

    Hope that helps,

    Mark
    Reply With Quote Reply With Quote
  8. 09-23-2010, 05:07 AM #8
    Chandrasheka
    Chandrasheka is offline
    VBAX Regular
    Joined
    Jul 2010
    Posts
    49
    Location

    String within String

    Hi,

    I am extremely sorry for that.

    Regards,

    Chandra Shekar
    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