split

Hi there! Hoping someone can help. So I have a table > column A has the ID, Column B has the Associate Name and column C has the badge type. What I want is to have 2 separate columns that list the names from the 2 separate badge types. How do I do this without using VBA. I'm trying to figure...

A SPLIT function (to break delimited text into separate cells) would be very useful. It is easy to do in VBA, which has a built in function to do it, but I thought I'd try to do it with lambdas. I found it extremely difficult (not least because it is so hard to check recursive lambdas if you...

I have large excel file with more than 20.000 rows I want to seperate every 700 row with same header and formula, and save as to a new file with name like this “file1-700”, “file701-1400”. until end of row, Any help would be great, really apreciate it

I have a large dataset of only 3 columns. I want this set to be split every x rows into a separate excel file, or workbook. I also want the header row to remain the same in all files. If you want a sample of what I am looking for I can provide some screenshots. I have looked everywhere...

I am trying to split out a workbook with about 100 tabs into separate excel files, so I can PowerQuery them. I have it to the point where it splits out my files and renames them and puts them all in a folder, BUT I would LOVE if I could figure out how to also have the VBA rename the worksheet...

Hello everyone, I have been looking but haven't found how to transport data from one big table to more smaller ones. In specific - I want to split it into more smaller pieces. I manually did it so you can see what I want to do automatically: (I post a SS because can't use mini-sheets via...

I have a number string in cell A1 that looks something like this: 12; 34; 56; 78; 90 I would like to extract each number into cells A2, A3, A4, A5, and A6, respectively. After extracting, cell A2 should contain 12, A3 34, and so on. Thank you very much for your help.

I have a list box on my VBA form with a list of U.S. States. The person filling out the form will select states they wish to be licensed in for work. Following their selection and submitting the form I want the states they have selected to appear in 5 predetermined categories with a "," between...

Hi everyone, I am hoping you guys can help me out with a roadblock I'm running into. I have this set of data, pretty linear, but one cell has multiple variables in it. I want to split the data in that cell, but duplicate everything else. Let me show you an example below: ORIGINAL DATA...

Hi everyone, I am trying to convert a 15-minute interval export into a 30 minutes interval and sum up the different values (Total 1 - Total 9) within that 30-minute interval. The data table is as below: Text Date TIME_Interval Split_Number Split_Name Total 1 Total 2 Total 3 Total 4 Total 5...

Noob here. I've seen some questions that are close to this (split sheets two at a time, etc), but I haven't found exactly what I need yet. Hoping y'all can help me out. I have a button set up that dynamically creates new worksheets based on data in sheet3. I have a second button that splits...

Hi, Can someone help me with VBA code to do the below task. I have data in A2-Z2 where in each there will be some data. this data in each cell migh be sepearted by comma. what i am looking for is to publish a out put in AB where it concatenates data from A2-Z2 by removing duplicates and...

I have an xml file that is about 80MB. I constantly have to import it in excel and do filtering in it. Sadly, it takes too long to open and sometimes crash. So I have decided to manually break it down into pieces. My steps are usually: 1-Use a software that split the files into multiple...

Dear Friends, I am now so close to finish my Access database (2016) which include both Front end and back end. This will be used by around 200 users. I have 13 table and 13 forms. Current size of the access is 30 MB. I think it will be 1 GB after a year. So I have a plan to use SQL Server as...

Hi, Can someone help we with a code for below scenario. I have data in A column and need to split it to B, C, D Columns. below is possible formats of data. 1. If it contains data with "AB" then it has to pull the 8 digit alpha numeric (8 numbers + 5 alphabets) ID and paste it in B column cell...

Need help to 1. Extract every words, after "Type>", in any position within a cell. 2. Split the results into 2 columns, after cross checked with existing list Hope these could be solved in 1 step. Please see attachment. Thank you Also posted here Extract every words, after certain...

Hi there, I have situation that requires me to split salary data per department so that each manager will receive a workbook for their team only. I do not mail these out to managers, I simply safe it in their respective folder on the server. I use this code, but this code does not split the...

I am working with a large xml files that is about 80000KB and it's full of data. It's bigger that the maximum allowed in excel. So When I try to import it as a table in excel I get an error. I am looking for alternatives on how to import the data in excel. I am thinking it may be best to split...

I am looking for a Excel Formula or function or VBA which is simple to understand. The actual data is Text and not a Numeric values The cell contents is to be divided into different sets with flower brackets and a comma separator. It should separate the data equally based on values in...

I need help, here I also attached image of excel sheet to explain my question. I have this installment payment sheet. Payed amount to be entered in column E. What I want, I want to enter amount in column E regardless of months for example I had payed 3,76,000 rupees in 15 July and then second...