substitute

Is there a simple way to find all double characters in a string (of variable length) and place another character in-between them? I'm completely stumped! eg. "MESSAGE" would become "MESXSAGE"

Hello, I found an old thread from 2008 that helped with extracting the 2nd last word from a string of text. However, when I apply it to my situation, it adds the comma that is attached to the word. Is there any way of getting this work without the comma? formula used: =TRIM(LEFT(RIGHT("...

I have two tables. One is a product table as shown below. The other is a transactional table, shown below the product table. The transactional table shows products purchased separated by a comma. I need to search the purchased products in the transactional table and replace with the short...

I have a formula that I will enter into a cell and drag down to about 6,000 rows. I need get the value in column C of each row, up to a colon, dash, the word "FOR" (upper or lowercase), whichever comes first. Then, I need to remove all of the following words: "Hump YM", "Trim YM", or "NX"...

Can anyone identify why the formula to match dates is not working, or alternatively provide a formulated solutions that does work? Excel 2010ABCDEF101-Jul02-Jul03-Jul06-Jul07-Jul2WednesdayThursdayFridayMondayTuesday3A B#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!4C...

So, I have a 40x2 table of non-systematic strings to be converted to other strings - think "LM" needs to become "2P9" and "ATT" needs to be "Y4," all just according to this table. I have long groups of things that need to be convered seperated by dashes (so something like "LM-ATT-etc-etc-etc,"...

I'm using Excel 2010 and am looking for some help to sum non-contiguous cells that have numbers and text in them. For example, I have "17 days" in cell B27, "66 days" in B31, "94 days" in B50 and so on. I would like to sum the numbers and ignore the text. Any help would be appreciated. Thanks!

Hi,<o:p></o:p> <o:p> </o:p> <o:p> Hi,<o:p></o:p> <o:p> </o:p> I’ve had many happy years enjoying VLOOKUP, but now I’vemoved on to a deeper relationship with INDEX MATCH ;o)<o:p></o:p> <o:p> </o:p> <o:p> </o:p> I am using INDEX MATCH to return values from a table with...

Good evening Forum and Happy New Year: I am trying to insert anchor/hyperlink I have in column A inside cells that contain product descriptions. Anchor Text I have in column A are 73 and in column B with descriptions of products I have about 1800 products. I like to insert automatically the...

Hello Everyone, Is there a way to apply multiple formula in one single cell? I need to apply 2 formula in one cell "LOWER" & "SUBSTITUTE". For instance: This tex: <tbody> "Lupo Heel N Toe Yoga Barre Pilates Socks" Should be: "lupo-heel-n-toe-yoga-barre-pilates-socks" Any suggestions...

Hi, I previously had some help from Istvan extracting the %'s of fabrics from certain cells. Now I would need to translate the different fabric types, just the names not the %'s of course. So I have the English names as starting point. Now I need to translate them to Dutch and French (more in...

Hi guys, Doing hundreds of UTM tracking codes and I need some help to shortcut. Basically the codes are the same across all platforms, but one or more of the terms is different for each campaign. An example: <colgroup><col></colgroup><tbody>...

Hello all, This is my first post on Mr. Excel.com. I work for a Machine Shop in the Toledo area. We use a quotation sheet to quote our products to our customers. It has 3 cells that describe the Customer, the Contact person at that customer and finally that Contact's Email Address. I have a...

Hey everyone, I have a list of Promotional Names that have garbage attached to the name. Examples: Bestbuy Stay 2 Save 20% Comcast-Stay and Save 50% Cox Advance Purchase What I need to do is create a list of companies on one worksheet and then substitute the...

If anyone can help me, I would appreciate the help. I am looking at creating a new function in excel. The function would perform the below action. function Extract_text(Lookup_Value, Within_Text, Number of Characters)...

I've been piecing together the below macro to insert a round function across a range of cells (Excel 2007). It just asks how many places to round to and drops in the formula on any cells with a value or formula. I am trying to add a level that will check if the cell already contains the ROUND...

Hi guys! I checked out and/or searched all the possible formulas that I can use for my project below but no luck so I have finally decided to ask this question... So, my spreadsheet has 12 columns that I need to concatenate using a space and dash.however, the concatenate leaves me with "-"...

Hi Guys, I've been searching around for a few days but can't seem to find what I am looking for. :confused: I've created a worksheet with several drop down lists that are INDIRECTly related to eachother. As there are several hundred options in each list, I would like the user to be able to...

What I am trying to do is eliminate all numeric characters from a text string in a cell... I know the following works but it gets quite large... assume G2 = 23ea =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G2,0,""),1,""),2,""),3,"") all the way up through 9 results in: ea What I would...

I have 11 cells that are part of my question, A1, C1, C2, C3, C4, C5, E1, E2, E3, E4 and E5. A user will have an option to input an arbitrary value such as 200 or 400 into cells A1, C1, C2, C3, C4 and C5. The user must always enter a value into cell A1, however, each cell C1 through C5 will be...