replacement

Hello everybody. I've a cell assuming different values. For example: 105,32 euro Now, with regex I've removed the non numeric value in order to have 105,32 My code: Dim replacement As Object, trunc As String Set replacement = CreateObject("vbscript.regexp")...

Hello everybody. I've been manipulating some strings. Now, I'm in a deadlock. I mean: in a specific string, I want to replace only the third occurrence of character "a" with character "b". How can I build the pattern (see in red below). Sub substitute() Dim lr As Long Dim Rng As Range...

Hello All, How do I modify formula below to return value with "Description:" in front? Example Value Return = Description: Cooling System Replacement =IFERROR(INDEX('Report'!R:R,MATCH(A1,'Report'!A:A,0))&"", "") Regards, Morey

using vba, how can i replace a specific text a sequencial number? for instance, i have j j j the replacement should be 1 2 3

Hello,</SPAN></SPAN> For now using in the cell C5 following formula, is there any replacement of this non-volatile formula to regular formula </SPAN></SPAN> Book1ABC1231245126172839510611101212134014601565167217381861Sheet2Cell...

Hi, I wonder if anybody could assist me in a smoothingformula I am struggling with, In this scenario I wish to take the replacementvalue/period of an item based on several inputs and in some instances smooththe resulting smooth the output over either 3,5,7 periods equally eachside of the...

Hi, I am trying to conditionally format a large amount of cells. These cells have these formulas in them. =IFERROR(IF(VALUE(VLOOKUP(B7,'Equipment Replacement Tracker'!$C$4:$G$3583,5,FALSE))=0,"Incomplete WO",VALUE(VLOOKUP(B7,'Equipment Replacement Tracker'!$C$4:$G$3583,5,FALSE))), "No Record")...

As I understand it, the combin & permut functions only calculate the results without replacement. There are no corresponding functions for with replacement. Is that correct? The formula for permutations with replacement is just n^k, but the one for combinations is ugly: (n+k-1)!/k!(n-1)!. Do I...

Good afternoon everyone, I have been given this exercise to complete and the instructions seem very vague so not sure how to solve the issue they are asking. Also the way they are doing some of the calculations are straightforward but really weird and do not make sense to me. Looking at the...

Good day I'm looking for a formula that can help with replacement years. Say I buy a Laptop in 2020, and have a replacement criteria in cell C3 that is "3" years. Thus I will this I will replace it in 2023 2026 2029 2032..... The formula needs to pull the cost into each Colum for the specific...

My workbook size is small, around 5 mbs, but at times gets hung up spinning with 4 processors anytime i move to a new cell. I have a summary sheet that references around 20+ other sheets pulling data via Indirect(Address). I believe this formula is slowing my workbook down. Is there a...

Hi! I'm working on an Excel VBA program and I'm at a point where I'm trying to reduce typing for data entry staff by allowing them to type in a part number and I will automatically insert the description or part name for them. No problem with that at all. It's been working perfectly...

Hey there, I am new on here, please bear with me. I have already knocked my head against the wall for a few hours and done lots of researching of examples, but I can't get there unfortunately. So what I was planning is pretty straight forward: Copy 2 rows from above selected cell and insert...

Hi there, I have been presented with some 20 plus templates, each workbook/template contains between 5 and 20 sheets, depending on the sheet, they make have extra items, charts, different shapes and maybe some tables. I have been told to change the generic colours to keep up with the new...

I have a single column range with strings of text similar to this: LIST 1 <tbody> COLUMN A <tbody> LID, PLATTER PLSK CLEAR </tbody> <tbody> SAUCE, CHILI MANGO </tbody> <tbody> SAMPLE, SWEET STREET </tbody> <tbody> SAUCE, ****TAIL SEAFOOD </tbody> </tbody>...

I have a pivot table showing a count of items in a library. However, one of the library names (Well Drilling Operations) is shown as a single quote mark ` . If I change the library name in the source table the pivot table shows the correct result, but when I change the source back to the...

I'm fairly new to VBA coding, or any kind of coding at all (had a brief experience on college, 4 or 5 years ago, but with C, html and whatever language Adobe Flash uses), so please, be as didactic as possible. I've came here with this problem (thread name: Boolean to String on the same...

I have a single column with more than 200.000 cells. In each cell there is a small image obtained from a website. There are four different images: red, orange, yellow and green . What I need is to replace all equal images by an equal string, such as =Q4, =Q3 and so on, or, at least, place a...

<tbody> A B C D E F G 1 1 1 US 1 1 1 1 3 2 US 1 1 2 2 3 3 CA 2 1 2 2 1 1 1 3 2 2 1 3 1 2 1 </tbody> In a very simplified world, this is my data, where 'A' represents the hub from which a car is leaving, and 'B' represents the hub to which the car is going. C, D, and E all...

I have this spreadsheet... <tbody> A B C D E 8:45 26 85 9:49 14 30 10:34 85 14 11:12 30 26 3:05 90 30 2:33 14 90 12:45 26 26 1:00 90 14 2:45 30 90 </tbody> I need to put a formula in E that says...