1. 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.
  2. D

    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...
  3. 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
  4. 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 ...
  5. L

    Breaking split at not 0

    Hello guys, I have a sequence: <colgroup><col></colgroup><tbody> 00000001 00000005 00000009 00000013 00000017 00000021 </tbody> I want to extend it indefinitely, well until it fits, but i was not sure what the best approach would be. I was thinking of taking it as a string...
  6. gheyman

    Split form Refresh Problem

    I have a split form based on Table. The below code runs an append query that updates the aforementioned table. My problem is that after the append query is run, the Split form does not refresh to show the new data that was added to the form. If I hit the Refresh button in the Ribbon the form...
  7. K

    Split Access Database Keeps Crashing

    We recently upgraded all our systems to Windows 10 64 bit and Microsoft Office Professional 64 bit. We were using a split access database with Office 2013 which was working perfectly. Since the upgrade, when using the database on one of the systems, it constantly crashes and then Access...
  8. smide

    Assign an index to each group identified by date

    Hello. In column A (A1:A600) I have a dates and time in format dd.mm.yyyy - hh:mm (example. 07.10.2019 - 21:00). Somehow I need to find an 'average' date for all those dates in column A (split data/dates in column A into two parts) and then to assign an index to each date (column A) according...
  9. L

    Split hours and minutes in two columns

    Hi, I need a sum of time to be displayed in two colums rather than 1. E.g. 7,4 or 7:24 needs to be one culumn with a 7 and another column with a 24. Any suggestions?
  10. J

    Splitting a cell by delimiter with formula. Warning: 312 splits needed for this.

    Hi! I can't seem to find a way to split cells in Excel using formulas (I need it to be dynamic, so I can't use the built-in splitter). What I have is up to 8 rows and 39 columns put into one cell. It's easy enough to get them spread out when I get them split up, but I can't split them. I can't...
  11. L

    split address using split in vba

    Hi I want to ask user to enter address for example 100 main street, and then my code will split the number and street name. I tried the following but got error message. I am thinking of array must be use or do you think there is easier way to do that thank you very much Sub myfirst() Dim...
  12. A

    <Expression not defined in context>

    When I run the following code, the watch window reports the following: Watch : : CurrentRegion : <Expression not defined in context> : Empty : Splitx.TestCode Sub TestCode() Dim arr As Variant Dim txtGPAddr1 As String Dim txtGPAddr2 As String Dim txtGPAddr3 As String Dim...
  13. T

    VBA to separate data in column using comma deliminator then put into new column

    I some data in lets say column D that has information such as: Product 1, Product 2, Product 3 Product 4 Product 2, Product 4 Product 7 etc. What i want to do is use a vba to turn this into one column somewhere else say sheet 2 column A so: the data would look like Product 1 Product 2...
  14. nikio8

    Alternative to solver, numbers (no more than 5) add up to goal, several hundred rows

    Hi team, I have a bit strange problem. Quite often one payment needs to be split to several invoices. Most days there are no issues, however some days this split data total does not add up to original number. If there is a difference I would like to use some formula to try to find combination...
  15. V

    UDF involving Split function or Formula Text?

    I created a UDF that calculates how many minutes it takes to complete a certain task. (ex: =MinutesToComplete(1,0.18,10,50,20) ) Is there a way to extract each argument/parameter? (ex: =RightParameter() ) and the answer would be 20
  16. M

    Access Split Database Issue

    I have a Front_DB_A with a table called RS and another Front_DB_B with a table called RS_Hist, both are split databases and have tables linked to the Front_DB_A database. My dilemma until we can move it to SQL Server which we are waiting on is that I have a run a query that will combine both...
  17. J

    Split function placement

    Hello, I am currently using a VBA code which extracts emails from outlook. I am attempting to use the split function in order to separate the body of the email using a colon as a delimiter. I am extremely new to VBA only learning what I can from forums and Google searches and one thing I've yet...
  18. M

    Splitting Data into Months based on Date Range

    I have been doing some research but was unable to find exactly what I am trying to achieve. I have been working with VBA frequently but am not quite advanced enough yet to do do this, so I would really appreciate some help! I have a list of customer bookings, with various information and a date...
  19. D

    Split Text Into Columns With a Formula

    Hi, I am trying to split text to always capture a specific item, I know I can do this using the Text to Columns function, but I need to do it with a formula as the text will change via a vlookup formula entered into the sheet. What I need is the always number after the *, in this example it...
  20. V

    VBA or Code For split the data

    Hi All, Thanks in advance, i have a data <tbody> Coloumn 1 Coloumn 2 2305 2054 0654 </tbody> now i want to split, but when we split the data, "0" is not coming <tbody> Col 1 Col 2 Col 3 Col 4 Col 5 2305 2 3 5 2054 2 5 4 0654 6 5 4 </tbody> pls provide the VBA...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...