+ Reply to Thread
Results 1 to 2 of 2

The opposite of concatenate function

Hybrid View

  1. #1
    Registered User
    Join Date
    07-08-2009
    Location
    Maccabim, Israel
    MS-Off Ver
    Excel 2007
    Posts
    12

    Lightbulb The opposite of concatenate function

    Hi everyone,
    i have this text in a cell: "black;blue;white;green"
    i need to put each word (color) in a different cell, the catch is that the solution has to be generic, because i also want to apply it to cells with less words (colors) in them (i.e. black;white;red).

    is there any way to accomplish that without using VBA?

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: The opposite of concatenate function

    Menu Data>Text To Columns with a delimiter of ;

+ Reply to Thread

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