duplicate characters

Greetings Excel Community, I am attempting to insert or duplicate a string value within a naming convention without having to do input manually. Is there a formula or a macro code that might be able to complete this possibly? Via the example below, I am attempting to duplicate the ID value...

<tbody> C1-a C1-b C1 prevent C2 C2-a prevent </tbody> Hi, I found many posts that have solution to prevent entering duplicate values in a column's cell. I am trying to solve the same problem which has little different flavor. In above table I want to stop users if they try...

Hi, I have a column with huge list of company names. I have removed the exact duplicate companies presented in the column. However, there are plenty of repeated companies name in the column with partial and real spelling of the company name. Eg: ABC inc ABC XYZ Data Inc XYZ Inc XYZ...

I have a list of terms in one sheet (Find List) I have a column of text data "Replace Data" in another sheet that I need to search for exact full words/phrases in the Find List and if multiple instances exist in the text data of Replace Data, I need to eliminate all instances of that exact/full...

I have a datasheet with duplicates values in single cell. I would like to delete them using Macro. Example: <tbody> <tbody> 108,125,98,90,113,64,89,71;61,38,57,53,51,30,39;29,25,19,7,5,61,38,57,53,51,30,39,29,25,19,7,5,61,38,57,53,51,30,39,29,25,19,7,5;61,38,57,53,51,30,39;29,25,19,7,5...

Hi... I need your help.. I ave two Excel File First file has this Name and Phone number. The first file are the new list of file that I will be calling to. The second file has Name and Number But in this file all of them already purchased an item from me. Now, I want no duplicate on the...

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"