kind

I have three text box. I’m looking for a formula to combine all three text box into text box number 4? Please help. I’ve not been able to come up with any kind of solution

Hello folks, here is what I am trying to do. I have a column of numbers like this: 091215421R And I need each cell in the column to be formatted like this: Q09-1215421 There are always 10 characters in the original cell. The last character may be anything but needs to be dropped. A...

Hi all, I am not sure if what I am trying to do it possible or not. I am not sure if maybe there is a way for me to set up and outlook template to work with excel? I want to be able to have a user click a link in a spreadsheet that will open up and auto fill an email with some of the fields...

I am really struggling with how to insert formulas in cells using VBA and loops and it would be very kind if someone can show me an example of how to insert different formulas in different columns. I would like to learn so that I can use this in my workbooks. Row1 contains headers from A1 to...

Hello, I have a function to validate URLs. It return as result "200" if the URL is valid and "404" if the URL is invalid. It works fine with simple URLs like: http://www.mywebsite.com/products/dresses/blue-dress But it not work properly with URLs which contain anchors (#). For this kind of...

I have a spreadsheet with a few hundred URLs in it, but for whatever reason they have all doubled up. For example, A1 looks like: "https://website.comhttps://website.com" Is there a way I can clean this up? Kind regards

Hi All, I've got a strange question here... I have a cell A1 that has the numbers '5/100' in it. I want cell A2 to calculate that to 5% I can't seem to make it work! Help Kind regards, Pharmacisticus

Hi On a line chart, how I do put a green ball next to each data point ? Thanks kind regards Kaps

To keep the look clean and simple on a few spreadsheets the desire is to have y, yes, n, no, na, n/a inputs from the user displayed as capital letters. looking around i found some vba code that will kind of do what i am after, but the way i typed it up, it cycles through all of the options in...

Hi All; Hope you can help. I have the following statement If IsText(Me!cmbCustomer) Then Me!txtEmail.Value = Application.WorksheetFunction.Offset(ActiveWorkbook.Worksheets("Website Orders").Range("O12"), Application.WorksheetFunction.Match(cmbCustomer.Value...

Hello, I am a basic excel user and now I have this huge conversion project and I am freaking out! Here is my question: I have this info in a cell: 6500-Operating & Maintenance:6515-Supplies:6515-01-Janitorial I need to move 6515-01 to another cell. Could some kind soul help me with a formula...

Hi! So lets say we have two sets of dates when something is predicted to be delivered/finished. Each set has two columns: Date of delivery and order number. Assume each order number matches between the two sets, it's just that each set has a different delivery date. If we wanted to see as a...

hi i have the following code: StrConv(Format((Now), "[$-809]MMMM"), vbProperCase) but he still gives me Juli instead of July What did i do wrong? Kind regards, Lesly

Hi all, this one is hard to describe, but basically I want to take a numeric value, then insert a character (text character or symbol, such as X) for each of the instances of that number. For example: If B2 has a value of 7, I want C2 to show a visual representation of the numeric value (7)...

Hi Excel Experts, I wish to create a formula which if H4 contains Greater, then A4-C4, otherwise C4-A4. I do not know why the formula below did not work (highlighted in RED), hence, I need your kind assistance on this issue. =IF(ISNUMBER(SEARCH("Greater",H4))," =ASB(A4-C4) ","=ASB(C4-A4)")...

Dear All, I have one query in VBA. I have attended interview. they ask "what kind of algorithm you have used in VBA". I have written VBA for automate the Pivot table , Saving the report from pivottable . Now what kind of answer i have to give. what are the Algorithm available in VBA. Please...

Hi I am a newbie to macros and i want to use macro to copy and paste the table data Please look into the below tables and you will have a clear picture of what kind of result i am looking for Input <colgroup><col style="width:48pt" width="64" span="13"> </colgroup><tbody> User O D...

Hello, does anybody know how to draw up an index-match formula with the possibility to search in another sheet, whereby using a dynamic entry for sheet? <tbody> sheet column row output 1 1 3 ?? 2 2 4 ?? 3 1 2 ?? </tbody> Kind regards, Niels

Hi there, I was wondering if anyone would possibly be able to be kind enough to help me with an issue that I am currently stuck on. cell a b c d e f g h i j k l m n o p q...

I am not sure if I ask for the right chart though... It looks like a chart plotted in cells, just like sparklines. Anyone see this kind of chart before? If yes, any idea how to create one? Thanks in advance!!