Results 1 to 7 of 7

Separating Data into different Columns

Threaded View

  1. #1
    Registered User
    Join Date
    07-03-2020
    Location
    Philippines
    MS-Off Ver
    Office 365
    Posts
    6

    Separating Data into different Columns

    Hoping you could. Newbie here.
    I have a list of software name with its version (Column A) and I need to separate the software name (column B) and the version (column C). I tried using a delimiter but would not work because the data in column A is complex. Would you be able to advise the best way to do this? I do not want to do it manually as the list contains around 8000 rows. I have attached a part of the list, for your reference.
    Thank you in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. NEED HELP, separating data inside columns
    By getwell in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-27-2019, 07:10 AM
  2. Separating data from txt to columns
    By kkostas in forum Excel General
    Replies: 2
    Last Post: 05-23-2015, 06:03 PM
  3. Separating Data in Columns
    By leepallister in forum Excel General
    Replies: 10
    Last Post: 05-04-2013, 08:59 AM
  4. Help separating data into columns
    By neal_dodd in forum Excel General
    Replies: 2
    Last Post: 12-16-2010, 06:24 AM
  5. [SOLVED] Separating data into columns
    By Jmarsh4 in forum Excel General
    Replies: 1
    Last Post: 07-01-2010, 12:49 PM
  6. Separating list of data into 2 columns
    By JLM in forum Excel General
    Replies: 2
    Last Post: 01-11-2007, 05:24 PM
  7. Separating Data Into Multiple Columns
    By penroma in forum Excel General
    Replies: 3
    Last Post: 05-26-2006, 03:24 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