Results 1 to 6 of 6

Need to split the data of a column into different columns

Threaded View

  1. #1
    Registered User
    Join Date
    04-13-2020
    Location
    NC, USA
    MS-Off Ver
    Windows 10
    Posts
    2

    Need to split the data of a column into different columns

    Here is the data from the column:

    01 Center\01.02 Center\01.02.03 Site place
    01 Center\ Site 2\01.02 Center\01.02.03 Site place

    I want to split this column data into two columns:

    Column 1
    01 Center\01.02 Center
    01 Center\Site 2\01.02 Center

    Column 2
    01.02.03 Site place
    01.02.03 Site place

    I used the wizard text to column feature to split on "\" but then it gives me 4 columns and I need two columns. Is there a formula code I can use to split this or would I have to manually add the "\" to create at least 4 even columns for all the data.

    Help appreciated!
    Last edited by nightangel73; 04-13-2020 at 11:18 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] 2 columns data split to more columns based on groups in 2nd column
    By vendam in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-09-2019, 05:43 AM
  2. [SOLVED] Split data from one column into two columns
    By augr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-01-2017, 08:48 PM
  3. [SOLVED] Split 3 data from one column to 3 different columns
    By naga in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 04-29-2017, 08:33 AM
  4. Split data column in more columns
    By mihai.bantas in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-07-2015, 07:09 AM
  5. Split data from one column into two new columns?
    By qcom in forum Excel General
    Replies: 2
    Last Post: 07-21-2011, 06:36 PM
  6. split the data in 1 column to 3 columns
    By ccs_1981 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-31-2009, 03:39 PM
  7. Split data in one column into two columns
    By maacmaac in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-12-2009, 05:07 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