substitute

The large text is imported from clipboard. I want to have a replace function in excel vba similar to replace function in ms word with the option find "whole words only". The replace function in VBA or worksheet function substitute is of no use. Here is what I am trying to do: Dim DataObj As...

Hi, I am currently trying to pick out our order numbers beginning 'RVW0' from cells with long strings of text. I have succeeded so far... however! Some idiot has been using underscores and now they're messing up my sheets! I need my formula to ignore everything either side of the order number...

Good afternoon all, I am very frustrated as everything i have tried has failed so let me explain: In Column E Row6 i have the following formula: =IF(ISNUMBER(SEARCH("WON",Jan!A6)),Jan!G6,"") - Working Good In Column J Row6 I have the following formula...

Hi I would like to replace the the last "." with a "0" <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> 1.1.7 1.1.8 1.1.9 1.1.10 1.1.11 </tbody> Much appreciated

Hey guys, hope you all are well. My sheet - I got - is a big mess. in the cells there is a full sentence with some numbers which I want to get, for instance: TEXT Fee: 123$ MORE TEXT Rate: 456$ MORE TEXT The sentences never have the same length and never the same text Main Problem: How...

Why not just use the sort function? Because I work with idiots and they'll be using this too. Problem, I can't get blanks spaces to stop appearing and I can't differentiate between two people with the same last name. When I can, I can't tell it to then look at first name to see who goes first...

Hi Everyone. I'm struggling with a functionality in excel / VBA. I have a list (one column) with 300.000+ entries. The length of each cell varies. For each cell over 35 chars, I need to perform substitutions in order to make it short. For that purpose, I have a range "from" --> "to", so at each...

Hi people :) I need a little help breaking down this formula into business language - I get the gist of it, but I need to be able to explain the "rules" used to create the values in this cell (formula exists in cell U1)...

Hey guys, I need your help. The situation: I have 10 standard six-sided dice and want to roll values of 4, 5 or 6. This for example represents a game with 10 Goblins attacking a Troll, needing a 4 or higher to damage it. However, the Goblins are quick to strike so they can reroll their failed...

Hi, I will greatly appreciate your help on this question as I've hit a mental block My question is about the correct syntax to use for my problem. Say, I have a formula in cell A1 on Sheet1 =Sheet2!N2+10 Say, I also have a cell on the same tab, B1, where letter N is generated by another...

I have been ripping my movie collection now for a little and need a little help with a database I am creating for it. I have a movie database list with the movie titles in column C, the year in column D, and the release version (Theatrical Cut, Director's Cut, etc) in column E. I currently have...

Hi everyone. I'm trying to remove a specific character ")" however, I need it to fit within my existing formula if at all possible. The formula already identifies "(" and removes the character plus everything left of it. I know that the substitute function is probably best here (either that...

Hello Everyone, I have excel column A where each cell contains a English paragraph. I want to remove all those words which contain "/" without quotes anywhere in the paragraph. I don't know how to do this. Regards,

Hi all, Looking for some help on the following: 1-How can I include a ‘range’ in a Substitute formula? the following doesn't seem to work (=SUBSTITUTE(A1:A4;"chien";"");"chat";"");"poule";"");", ";"") Thus the solution found so far is based on copying the cells downwards (see below example)...

To whom it may concern, I am having a problem for a couple of weeks now wherein I am trying to find the Match of Table C to Table based on CF General and Dates, and then convert them to USD. I have been using a couple of combination of formulas (Vlookup, SUMIF, Substitute) in the formula bar...

Hi, I have 205 (general format) in cell C13, 171.08 (general format) in C14. 205 is 205 hours, 171.08 is 171 hrs 8 minutes. To subtract these I an using the following-> =SUBSTITUTE(TEXT(D13,"00.00"),".",":")-SUBSTITUTE(TEXT(C13,"00.00"),".",":"). My result is -9:52 (format h:mm). It should be...

I have following code for exporting data to another workbook: Public Sub EXPORTPLAN() Dim Ans As Variant Ans = MsgBox("Are you sure?", vbYesNo) Select Case Ans Case vbYes Dim LastRow As Integer Dim wSOURCE As Worksheet Dim NextRow As Integer Set wSOURCE =...

First post, hope I'm doing everything correctly...I tried searching this and couldn't find what I needed and I'm in a bit of a hurry, so I hope I explain myself well enough that someone can help quickly. Ok, so here goes: I copied and pasted a table of data from a website - columns have a...

Hello, everyone. Thanks for taking the time to read my post and to try to help. I have one column of comma delimited names (ie, "Bill, Sue, Carla-S, Dave") that I would like to search against another pair of columns -- one that has a single name per cell, and its neighboring column with an...

Hi, I am trying to find a sub-string between two spaces in a string. Example String; 2PB IND3A 1MLGSTWIEL ANO I would like to extract 1MLGSTWIEL So far I have this formula... =IF(ISERR(FIND("ML",A1)),"",RIGHT(LEFT(A1,FIND("ML",A1)+1),LEN(LEFT(A1,FIND("ML",A1)+1))-FIND("~"...