1. S

    How to split numbers separated by semicolons in a cell?

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

    Getting one List (VBA ListBox) to filter into 5 categories based on selection

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

    VBA to split delimited data in cell and duplicate row

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

    Need help converting 15 minutes intervals into 30 minutes interval

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

    Split all sheets into separate workbooks, but always include "sheet2" with them

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

    VBA code to Conactenate the data in a row by removing duplicates and sepearating it by comma.

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

    Parsing a text file

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

    Questions about usage of SQL Server as Back end and MS Access as Front End

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

    VBA code to split the data as per requirement based on key words

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

    Extract every words, after certain character, in any position within a cell. Then split

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

    Split a worksheet to separate workbooks by column using VBA in Excel 365

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

    Split large xml files into multiple

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

    Split cell contents in different sets

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

    split amount conditionly

    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...
  15. Johnny Thunder

    VBA Help - Build Formula based on Variable Count

    Hello All, I am working on a project that has several macros but there is one piece of the puzzle I am unable to completed. I will do my best to explain what I need visually. I have a loop that looks at a sheet (Timing Assumptions) and based on a row called Percentages, the user is able to...
  16. A

    Excel macro -Split semicolon separated entries to new rows

    I currently have this data in a sheet Sl No Date Reviewed by Assignment Pole Number Feature Class Attribute Error Category Observation 1 8/2/2019 Bob.B Batch1 101039656 Cross-Arm Rotation Attribute Arm is reversed, causing primaries to cross; Delete riser. 2 8/2/2019 Bob.B Batch1...
  17. M

    Split string into numbers in Excel VBA

    The string can be like "abc123(456 k789)". It is to be splitted in array like array[0]=123, array[1]=456, array[2]= 789. So the problem is to split array based on numbers.
  18. darrenmccoy

    Help to split address into columns

    Hi Experts, Could you help me with formulas to split addresses? I need to count the spaces from the left and split the street number into column B, then split the street name(s) into column C, then count the spaces from the right and split the the street type into column D...
  19. G

    Split value in half and add

    <tbody> A 500 B 750 C 750 </tbody> How can I split A in half and add the half (250) to B & C to equal 1000 or it can not be done? Thanks in advance GT
  20. P

    Selecting data based on cell entry higher in column

    Hi, need help with the following. Have a workbook with 1200 lines and 4 columns. Its a list of building material for a office block split by size. For each size there are a number of different products listed. These are then replicated over the 49 floors of the building. Sample below ...

Watch MrExcel Video

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