I am attempting to remove a character from a cell by using a macro with some
VB coding. The cell contains a "special" character in the first position.
The character appears similar to a "bullet" in a word document. The rest of
the cell contains numeric characters. My questions are 1. How do I determine
if the character is present in the cell and 2. how do I remove it, replacing
it with a space character or triming the character from the Cell/Variable.

If I look at a the spreadsheet I can manually detect and Remove/Replace the
character.

The way I do it is :

=If (CODE(A1)127, TRIM(REPLACE(A1,1," ")),A1)

In my macro I have the contents of the cell to be reviewed in a variable
labeled CONTENT .

Thank You in advance for your suggestions.

Greg