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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top