split cell contents

  1. D

    Automation of Tabs

    Good Afternoon is it possible to automatically create tabs from text in a xls book and populate the new tab with data split by comma using the colors column? From this master sheet containing data, I need to create unique tabs based on color. I'm thinking of pressing a button and a...
  2. L

    Split by delimiter question

    I have looked at other questions but haven't quite found the answer I need. I have a column with data in it split by delimiter ; 1;4;10;23; etc.. each row could have anything from 1 to 26 items in that column all split by delimiter I have 26 columns set up to take the data one column...
  3. T

    Split string without delimiters

    Greetings, I am analyzing protein sequences, and wanted to use Excel's tools to facilitate the analysis. For that, I wish that all amino acids (1-letter abbreviation) occupies its own cell. The main problem is that the sequences come without any delimiter, and they can be quite long (hundreds...
  4. O

    (Power?) pivot: filter or split comma separated data in one cell to multiple columns in (power?) pivot table (by measure?)

    Í'll try to explain with data table/power pivot. I want to split the intervals (without ", ") in the column SectionS (plural!) giving each interval it's own column (with corresponding section as name) into a (power) pivot table. I guess using DAX is the only way... but how? I'm no Ferrari ;)...
  5. M

    Split excel cell based on its length

    Hello, I have 3 columns in the excel sheet and I want to split the third column based on the cell's value length (> 40 CHARS) into a new row, but the code should also copy the values of Columns 1 and 2. Example as below; Initial State: Column A Column B Column C Breed Husky Siberian...
  6. M

    Power Query split?

    I have a table with a column that has full paths/categories on it: BaseCategory/SubCategoryA/SubCategoryA.1/SubCategoryA.1.1 OtherBaseCategory/SubCategoryB/SubCategoryB.1 How can I split the paths/categories using Power Query so that I can get all the previous categories as well: Full...
  7. B

    VBA transferring cells with defined content from a worsheet to another

    Hello everyone, I would like to know how I could transfer cells from a worksheet to another, regarding the content of the cells. For instance, I have a first worksheet with cells that can contain "january" or, "february", or any months, and then I have a different worksheets for each month. I...
  8. K

    How to split data in rows within a cell

    I have this data within a cell cars; boats; autos; tractors; buses I want to sort in alpha order and split the data so each term is on the next line so to look like this within the cell autos boats buses cars tractors
  9. R

    Splitting cell values based on 12th space from the right

    Hi All, I currently have data sitting in the first column A in the following format representing line items from Period 1 to 12 4-4030 Fees and Charges-Unrestricted 5,623 5,811 5,610 5,733 7,563 5,417 5,484 6,152 10,962 4,487 4,835 4,412 72,091 73,660 (1,570) 4-5035 Recoupments 0 0 0 0 0 530 0...
  10. R

    Need help to create a new line for cell content after comma

    I need to do that so I can bulk add those words into a free course that I'm creating at Memrise. This is what i have: https://www.dropbox.com/s/ypb2r40hgyita96/Photo%2004-11-18%2002%2035%2023.png?dl=0 And this is what I expect do do for every case into the spreadsheet...
  11. R

    Split First and Last Names, removing any middle names

    Hi I need to split First and Last Names, removing any middle names as per the table below; <tbody> <tbody> A1 B1 Currently Becomes Walker Barbara Ann Barbara Walker Taylor Ron James Ron Taylor Clark Steve Steve Clark Price Kevin Liam Pat Kevin Price </tbody>...
  12. 2

    Split Multiple Names in One Cell

    Hi All, I have data that has multiple names all in one cell, which looks like this: A John Smith B Dave Smith C Jack Jones D Eric Jones Is there anyway I can split the names into individual cells? It is ok if the letter comes with the name like so: A John Smith B Dave Smith C Jack Jones D...
  13. J

    Split String into 2 Columns by 40 characters and 800 characters, Whole Word

    I have 90-120 character strings in Column A. I need Column B to take the first 40 whole word characters and Column C to take the remaining characters up to 800. I have been researching a solution to this problem and everything I have seen has been slightly off from what I am looking for. I am...
  14. SantoOnofre

    VBA: Splitting a big string with no good delimiters

    Dear all, I need to split a large string from a single cell, with no good delimiters. It's a 'point-by-point' date from a tennis match, exported directly to an Excel workbook from a third-party software. Unfortunattely, I do not know the VBA language enough to solve this by my own, and I could...
  15. C

    split cells & copy across rows - what's wrong with my vba?

    Hi All! First up, new poster, and VBA isn't my best programming language. So, apologies if I've stuffed up something stupid -- I'm learning :laugh: Now, I've got a database full of rows of different cases, and I'm trying to split the cases so that there is only one "citing judge" per row. Each...
  16. D

    Split delimited data in one cell to multiple rows using macro & apply to whole column

    Hi All, I routinely have a column of data which is quite lengthy with each cell in that data containing numerous names separated by a ";". I want to split those names to individual rows to a 2nd column. I found some code online which accomplishes the split portion. See below. What I would...
  17. J

    VBA code to split a cell at a space into 2 cells

    I have a sheet with a column of data that looks like this: thisisallonebigword nnn.n So 2 parts separated by a space with the n=to numbers, seconds actually. Anyway I need to run down the column and split it into 2 columns, the text in one, the numbers in the next column. This is the last...
  18. U

    VBA - Splitting Data in One Cell into Multiple Cells

    I am trying to split data in one cell into multiple cells and then copy it into a new page. With the code below which I have obtained from Excel VBA- Split Cell Strings into individual cells and copy cells to new sheet - Stack Overflow I can split, copy and paste data for the "Setup" rows and...
  19. Manolocs

    Split cells text between more than 4 spaces

    Hi, I know Text to Column option can be used to split text but split every word with a single space to different cell. What I am looking for is a way to split a cell every time there are more than one space between the words. In this case the strings are separated by more than 4 spaces...
  20. M

    Compare 2 columns that contain sentences and return matching words in the 3rd column

    <colgroup><col><col><col></colgroup><tbody> Column A Column B Column C appartement a louer appartement a louer limoges appartement a louer appartement a louer appartement grece appartement barcelone hotels a gotic No Match barcelone barcelone hotel barcelone borussia dortmund liverpool...

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