seperate data

  1. S

    HELP! New to coding-need to split workshhet into multiple by finding a word that ends the data each time

    Hi. I am not really a coder and this is new to me but I have an extremely large spreadsheet I need to disect into a seperate workbook for each set of data. While browsing on this forum I saw many references for splitting data, but it always split it due to a certain value in a column. My...
  2. C

    Seperating data / Opposite of concatenate

    I have the following information all stored in 1 cell. and i have 100 of these! Amraser Straße 6 6020 Innsbruck Einzelhandel mit Lebensmitteln; Großhandel mit Lebensmitteln; Großhandel mit Obst, Gemüse; Marktfahrer; Export-,Import-,Transithandel Folgende Kontaktdaten sind vorhanden...
  3. R

    Splitting text into the row below with changing delimiters

    Hi, Was wondering if someone could help me at all? I have the following in an excel sheet. Column A Software defect;#19 Software defect;#19;#Capacity;#2 Software defect;#19;#Capacity;#2;#Monitoring & tools;#14 What I'd like to do is: 1) remove the # and number i.e. #2, #14...
  4. N

    seperate two lists by x amount of rows

    ****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List"...
  5. D

    Seperate data into rows

    I have data that is in one row and needs to be seperated into several rows. see example. In this example I would need 4 separate rows for the 1st line and 5 seperate rows for the 2nd line . Each row would be identical to the root except for column C. Column C is the factor that determins how...

Some videos you may like

This Week's Hot Topics

Top