I am looking a macro which should perform below activities
I have a lists of suppliers which needs to cleansed....
1.replace all the special characters with a space
2.replace Corporation with Corp Incorporation with Inc Limited with Ltd Limited partnership/ltd partnership with LP Company with Co ASSC/ASSOC with ASSOCIATION/ASSOCIATES (SEARCH SUPPLIER IN GOOGLE FOR THE CORRECT ONE) MGNT with MANAGEMENT SVCS with SERVICES DEPT with DEPARTMENT Unltd with UNLIMITED Ctr with CENTER UNIV with UNIVERSITY
3. Remove any text, Special characters and numbers after INC,CO, LTD, CORP,LLP, LLC
The macro should when I select any particular column... not restricted to column A
I want to write a macro that will check every selected cell. It should detect if there is a space after the fourth character. If there is a space, go to the next selected cell. If there is no space, add a space and go to the next selected cell.
I want to remove the front zero(s) from the front and put a space before the last two letters for the following column of data in Excel:
0001MG 0020MG 0100MG 1000MG
Final result will have this format and the data are right aligned. 1 MG 20 MG 100 MG 1000 MG
The numbers can vary (e.g. 0150MG, 0025MG,etc.) but the arrangement is always the same: four figures for the first 4 characters and two letters for the last two characters. The format of the cells containing the data is: “General”
My table has 7 columns and these data are in the 5th column in a worksheet called “ProductSummary”. The number of rows for the records can vary from 10 to over a couple of hundred.
How can I use VBA to: 1) automatically select the table range in that worksheet and reformat all the data in the 5th column.
I was able to get rid of the weird character  with the =CLEAN(E11), where E11 had the problem character. but now where the  used to be between to words the 2 words just show as 1. Example If the bad cell was justtest the clean cell has justtest without a space between the 2 words. Since the spreadsheet is about 8,000 cells and has random  characters is it possible to not just clean the bad characters, but add a space where they used to be all in one command?
I can't use the "" sign as delimiter to separate them into different columns because the age,city,name and height fields are in random positions on different cells.The good thing is person's name will always come after "name" string, age is alwals followed by "age" string, so it cannot be like nameheight40Michigan180
I think the following would be the easiest method(not for me tho).If on B1 I had a formula that said "find the string "name" and write anything after it until you reach the next "" character".On C1 field I could have a formula "find the string "age" and write anything after it until you reach the next "" character.On D1 I would have the same for "height" string,then on E1 for city string.
My question is somewhat similar to this one Extract A String Between Two Characters
Formula which outputs the data between 3rd and 4th instances of the "_" character.Can we substitute "3rd and 4th" with a specific strings like "age" or "height" ?
On sheet one, in the column column C I have cells which have characters separated by a space character (For example cell C3 looks like this: "L C"; cell C12 looks like this: "S BF54FR"). There are only a few cells which have more than three characters. The characters are separated by a space character. I would like the macro to do the following: take out each on of the character in put in the same row next column. (For example if in column C has the value: "L C" then in the same row column D should have the value "L" and column E should have the value "C". Or if column C was "S BF54FR" then column D should have the value "S" and column E "BF54FR".
I'm looking for a way to extract the data after the first space in a string to after the first set of numbers (always 8 digits). The formula I'm using is not accurate since the number of words that appears between the first space to the first set of numbers changes.
I am interested in some sort of macro or formula that will strip all of the characters in a cell that come after that last space. My difficulty lies in that the string isn't a constant character count nor is the string always the same.
American Legion Post 8754 Hartford YWCA Canton
I would like for it to say: American Legion Post 8754 YWCA
I am trying to split a string into separate cells. I have managed to generate the formula for the description and first dlr value in the string but I am have trouble figuring out how to build functions for the rest of the string.