split cell values

  1. N

    Splitting one row into multiple rows using cell value

    Hello, I am new to this forum AND new to coding in Excel. I need to split data from one row into multiple rows based on the number in that row AND simultaneously assign a new value to another column based on another cell. Here's what I mean: AD young 2 10 2 7 2 8 2 10 1 5 2 5 I...
  2. T

    Formula for moving part of a name across to another cell

    Hi all, i am trying to work out a formula to move last names across to a different cell from the below table. Please note i can only use formula and cannot use text to columns <colgroup><col><col></colgroup><tbody> Candidate name Formula Aaron Holt Abhishek Wason Adam...
  3. F

    How to split string values using delimiter into multiple rows in Excel 2010

    Hi, I need help in splitting string values for multiple columns into multiple rows: Here's how my data is currently stored: <tbody> School Name Cluster Name Pathway Name Program Name Course Name School 1 C1;C2;C3; P1;P2;P1; PG2;PG14;PG19; CS1,CS3,CS5;CS6,CS9,CS10;CS11,CS12...
  4. K

    split characters in one cell to columns and create new columns

    I have a table and I need to split characters within a table in easy way <tbody> ID q1 q2 q3 1 0301|0303|0307 07065|07567 090861|090862|090863|090864|090865|090867|090869 2 0301|0303|0307|0308 07565|07567|07569 090861|090862|090863|090864 3 0301|0302 07457|07458 090861|090862 4...
  5. S

    how to split copy the cells/entire row to another sheet?

    Hi, I am very new to excel. I am trying to split the string between the delimiters And I want the splitted output to be printed in the another sheet. I am giving input in sheet named "Split", as A1 A2 A3 A4 a/b/c 10 10 10 d/e/f 20 20 20 g/h 30...
  6. M

    Split cell values

    I've got a few worksheets that each have a lot of cells filled with the beginnings of zip codes and I'm looking for a way to split the cell values to actual zip codes. The values in cells vary from single zip codes ("03" = 03000) to combinations ("11,215-219,30" = 11000, 21500, 21900, 30000)...

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
Back
Top