Results 1 to 3 of 3

Separating text using keyword in a cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-28-2010
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    105

    Separating text using keyword in a cell

    Hi I have the following text in A1 (breaks included)


    "Participants: SeniorBridge Family Companies, Inc. (Investor / Buyer)

    Pre-Deal Situation: -

    Deal Resolution: SeniorBridge completed the acquisition of Senior Care Consulting on December 22, 2009.
    "



    I would like a formula that can take this text which is in A1 and only shows me the text after "Deal Resolution: "

    So it would read.

    SeniorBridge completed the acquisition of Senior Care Consulting on December 22, 2009.
    Last edited by NBVC; 01-11-2011 at 03:20 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1