+ Reply to Thread
Results 1 to 4 of 4

Split Text Idea

  1. #1
    Forum Contributor
    Join Date
    06-01-2014
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Microsoft 365
    Posts
    224

    Exclamation Split Text Idea

    Hi Everyone,

    I am looking for a creative way to separate a text string within a single cell.
    e.g. Text:
    2016-2018 Audi A3 Sportback e-tron 2018-2020 Honda Accord 2016-2016 Scion iA 2017-2018 Toyota Yaris iA

    I am looking for any possible way to split the text or insert a line break at every instance of a combination of years occur,
    in the above sample text we have 3 such instances 2018-2020, 2016-2016 & 2017-2018

    The expected output as follows within the same cell:
    2016-2018 Audi A3 Sportback e-tron
    2018-2020 Honda Accord
    2016-2016 Scion iA
    2017-2018 Toyota Yaris iA
    Last edited by ibuhary; 11-17-2020 at 06:42 AM.

  2. #2
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Split Text Idea

    Just for your example
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    if you would like to change then you can use replace tool ( ctrl+h )
    enter Find what : " 20"
    switch to Replace width: (clear all here)
    enter ctrl+j and type 20, there will nothing in the field but be sure it's ok
    click replace or replace all.
    Last edited by BMV; 11-17-2020 at 01:30 AM.

  3. #3
    Forum Contributor
    Join Date
    06-01-2014
    Location
    Riyadh, Saudi Arabia
    MS-Off Ver
    Microsoft 365
    Posts
    224

    Re: Split Text Idea

    Thanks for the Idea. It will be useful.
    Actually we have some years from 1900 as well, and the process I am going to try inside Power Query as the data is quite large.
    So I might need to specify multiple strings to replace.
    Anyhow, thanks for the simple solution.

  4. #4
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Split Text Idea

    Quote Originally Posted by ibuhary View Post
    Actually we have some years from 1900 as well,
    Please Login or Register  to view this content.
    or
    ctrl+h " 20" ctrl+j20 replace " 19" ctrl+j19 replace

+ 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. Replies: 1
    Last Post: 05-06-2020, 07:42 PM
  2. Replies: 9
    Last Post: 01-04-2017, 03:35 PM
  3. Replies: 4
    Last Post: 11-11-2015, 03:00 PM
  4. Replies: 2
    Last Post: 04-09-2014, 11:48 AM
  5. [SOLVED] Text is changed to current date date when row is selected. No idea why?
    By rhug in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-10-2013, 02:41 AM
  6. Replies: 4
    Last Post: 07-25-2013, 05:28 AM
  7. How Do I Split Text Based Upon Two Values To Split
    By HowdeeDoodee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2012, 05:05 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