+ Reply to Thread
Results 1 to 2 of 2

Loop throug text and use separtors to separate text and put into separate cells.

  1. #1
    Registered User
    Join Date
    08-18-2020
    Location
    Valencia
    MS-Off Ver
    Mac excel - Office 365 - v 16.72
    Posts
    61

    Loop throug text and use separtors to separate text and put into separate cells.

    Hi guys. I have about 1000 likes similar to these.
    Abide by Accept or follow a decision or rule.

    I need to separate this sentence into 3 parts and each in a row and in separate cells as follows.
    Abide by Accept or follow a decision or rule. We have to ABIDE BY what the court says.

    Then it needs to loop through the whole sheet.

    I must admit I'm lost.
    The separators could be
    1 - Step 1: Copy the strings until "a capital letter is reached"
    2 - Step 2: Copy the strings until "period" is reached.
    3 - Step 3: Copy the strings until a "period" is reached.
    Start row 2
    steps repeat

    Any help would be grateful.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Loop throug text and use separtors to separate text and put into separate cells.

    maybe try

    attach.png

+ 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] Separate Text in one cell into 3 separate cells
    By Kathleen N in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-30-2018, 04:43 PM
  2. Replies: 0
    Last Post: 06-16-2015, 08:52 AM
  3. Replies: 5
    Last Post: 03-21-2015, 04:14 AM
  4. [SOLVED] Excel2010 IF Formula to return value based on a separate date and two separate text values
    By jakecutler in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2015, 03:24 AM
  5. [SOLVED] Separate numeric/text combination into two separate columns.
    By Jim15 in forum Excel General
    Replies: 6
    Last Post: 10-09-2013, 05:49 PM
  6. [SOLVED] Splitting text from one cell into separate text fragments, Located in adjacent cells
    By onsid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2013, 08:32 PM
  7. Separate Text into separate cells
    By Rokketman in forum Excel General
    Replies: 1
    Last Post: 09-09-2009, 09:03 AM

Tags for this Thread

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