need vba

I have text in column A spread out over as much as a few hundred cells. The data contains normal sentences and paragraphs along with occasional dates which will show up in any one of four different formats in general being: M/D/YY, MM/DD/YY, M/D/YYYY and MM,DD,YYYY. What I need to be able to do...

What I need to be able to do is have the VBA eliminate any an all letters whenever they are both preceded by a blank space(s) PLUS followed by a period and one or more spaces. However, never delete the letters when any other character is before or after them. Examples: ( M. ) ( P. ) The...

Need VBA code to cap only select words that will be found throughout columns A-F and a list of the select words that the code would look for would be on a separate worksheet named “words2” in column A so that additional keywords could be added on an ongoing basis.

I have been using a code that had been working fine but with the new data I'm using it has a flaw. Below is first the actual code I'm currently using followed by an explanation of the flaw I am now encountering. Sub ConvertSelectionUpper_V4() ' hiker95, 08/27/2014, ME800718 Dim c As Range...

Hoping someone can help with this one. In columns A through G, I need a VBA code that will eliminate the first character only in each cell and only when that first character in the cell is a blank space or a colon ( : )or 0 (zero-numerical). However, all other cells would remain unchanged...