+ Reply to Thread
Results 1 to 5 of 5

Assistance on how to grab text from a paragraph in one sec

  1. #1
    Forum Contributor
    Join Date
    05-17-2012
    Location
    Silver Spring
    MS-Off Ver
    Excel 2016
    Posts
    212

    Assistance on how to grab text from a paragraph in one sec

    Hello, if one cell in Excel has a paragraph that only the middle text changes.

    Example: (The cell is A1) and it has the following text

    The following users are listed in this group :

    David Smith
    Thomas Smith
    Henry Smith
    Jennifer Smith

    Published Date: 2015-05-25
    Blah blah blah


    End of example:
    How can I tell the cell above to just give me the names. It could start at the : and end at Published.
    I'd like to be able to grab the names and if possible put them in their own cells.

    The idea behind this is, I will have multiple cells all with this type of paragraph so for each cell I'd like it to just retrieve the names only.
    Can this be done?

    Final goal:
    A1 is the original paragraph
    A2 is David Smith
    A3 is Thomas Smith
    A4 is Henry Smith
    A5 Jennifer Smith
    Help?

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Assistance on how to grab text from a paragraph in one sec

    Here's a possibility...

    With A1 containing a list of names (delimited by line-feeds, and preceeded by a phrase ending with a colon, and ending with a phrase beginning with "published")...
    this formula, copied down as far as you need, begins the list of individual names
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Contributor
    Join Date
    05-17-2012
    Location
    Silver Spring
    MS-Off Ver
    Excel 2016
    Posts
    212

    Re: Assistance on how to grab text from a paragraph in one sec

    Thank you Ron for the quick turn around. It didn't work for me. Let me show you the exact sample I'm working with. Its a cell from a .csv file. Each one of these cells are in the 1 column (A1, A2, A3, etc)
    I need to have it put the Names out.

    Final goal:
    A1 Original Info
    A2 is David Smith
    A3 is Local\John Smith
    A4 is Local\Melissa Smith
    A5 is Local\Thomas Smith

    Then B1 through B5 it collects the names from the next cell




    Example:
    Synopsis:

    Description:

    Solution:

    Risk Factor:

    Plugin Output:
    The following users are members of the 'Administrators' group :

    - Dave Smith
    - Local\John Smith
    - Local\Melissa Smith
    - Local\Thomas Smith


    Plugin Publication Date:

    Plugin Modification Date:

    Plugin Type:

  4. #4
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Assistance on how to grab text from a paragraph in one sec

    Thanks for the better example.
    Try this formula, copied down as far as you need.
    Please Login or Register  to view this content.
    Does that help?

  5. #5
    Forum Contributor
    Join Date
    05-17-2012
    Location
    Silver Spring
    MS-Off Ver
    Excel 2016
    Posts
    212

    Re: Assistance on how to grab text from a paragraph in one sec

    This worked Perfect, Thank you very much for your assistance. Its greatly appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Text separation from news paragraph
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-28-2013, 05:15 AM
  2. Help with parsing & formatting a paragraph of text please
    By Remiel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2010, 12:16 AM
  3. Paragraph formatting text
    By rebbrann in forum Excel General
    Replies: 1
    Last Post: 03-04-2007, 01:23 PM
  4. [SOLVED] How do I add a make a new paragraph in a text cell?
    By bearntrail in forum Excel General
    Replies: 1
    Last Post: 07-05-2005, 06:05 PM
  5. How do I add (auto text) to a paragraph?
    By Lisa Nelson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-04-2005, 12:06 PM

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