split

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

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

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

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

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

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

Greetings, I import names and addresses into a database for mailing lawn care offers. I get the data from various county administered tax rolls. I can specifically target particular neighborhoods. The data is different in the various counties we serve. The homeowner names are in various...

Hi Friends, I been trying to split text into columns but did not find a suitable post over here. Here is the sample file with data extracted into columns Manually, its taking long human hours to complete. https://spaces.hightail.com/space/OU0YRqc7Yl I do not know if it is possible with...

I need to split the column into text please can someone tell me how to do this in google sheets <tbody> AJANTPHARM19JAN1180CE CE AJANTPHARM 19JAN 1180 ADANIPOWER19AUG65CE CE ADANIPOWER 19AUG 65 APOLLOHOSP19AUG1400CE CE APOLLOHOSP 19AUG 1400 </tbody> Above is an example of how the column...

Hi All, Is anyone able to help me with an odd excel question. I need to split rows into new rows with qty 1. Eg Columns Stock Code, QTY, BIN Row AB 10 AA-AA-AA I need them to come out as: AB 1 AA-AA-AA AB 1 AA-AA-AA AB 1 AA-AA-AA AB 1 AA-AA-AA AB 1...

Hi all, I have a PDF with 20 pages and I want to split it into 20 different pages. I wonder if, appart from the first petition, could it be possible to rename those files that are going to be splitted, based on a list of names that should be in an Excel file. Any ideas? Thanks in advance for...

How can I to split data in WS Sheet Column 'D' into Columns 'C' thru last column and place it under the right date. For example the Template sheet would have all the team schedules under the date they play, the court they play on and the time. A snippet of my macro thus far is shown at...

Good afternoon all, I'm struggling with a double donut chart. I know exactly how I want it to look in my head, but when I create it on Excel, it doesn't look the same! I have a number of products, in a number of regions. For instance: Product A has 10 in Region 1, 10 in Region 2 and 0 in...

Hey my friends, In cel A1, there is date and time together. I need a formula to split them into following columns as it is shown in attached file. Pls check the link: https://jumpshare.com/v/sSGwGXDJPfVWcl4UwBcf (Click "Download" button in up-right part of the page) Waiting for your help. Thank you.

Field contains 1990NorcrossRoad I need 1990Norcross Road

Hello to everyone. I use this code to split text in to separate colums <tbody> Row/column A B C D E F G 1 Split text in rows 2 Split text in rows 3 4 </tbody> Sub SplitTextColumn() Dim i As Long Dim vA As Variant For i = 1 To Range("A1").Rows.Count vA =...

Hi Awesome people, I need help please. What the formulato use if I wanted to split text. For example <colgroup><col></colgroup><tbody> 19,BMW,G02-X4,G02 - BMW X4 xDrive20i I wanted to use formula just to pick up G02-X4? Thanks AA </tbody>

Hi, I've got a piece of code I found online and it works awesome in Excel for Windows. It takes a long list of data and saves out separate files for each unique value in column A. However, when running it on Excel 2019 for Mac, it does not use the unique values in Column A for the file name, but...

Hi, i have several rows that contains some text "xxxxxxxxxxxxxxxx (xxx)" all of them has ()at the end. i wonder how can i cut (xxx) data to new column. Thanks!

hello all, newbie here. need a little help with an excel spreadsheet i am making. here is the cell fomulas - 61% FORMULA.. =SUM(D12+D13+D14+D16+D19+D20+D21+D22)*0.61+D15*0.5-(D38/2) - 39% FORMULA.. =SUM(D12+D13+D14+D16+D19+D20+D21+D22)*0.39+D15*0.5-(D38/2) the end result are the fees to...