Remove a specific character in a cell of numbers

[Guzzlr]

Hello All,
I have a little issue.
Column C has a list of data sets per cell. For example: 323DTD., would be in one cell. Another cell will have 665E.BD. Each cell has a combination of Numbers and Letters. However, the period (.), is what I wish to get rid of, and not every data set has a period...but the majority do.
I can't use the =LEFT function, because not all cells have the same number of characters, and the period is located in different areas.
The sheet already is a macro, so adding code will not be a problem. I was thinking of a last row scenario, but I don't know the code to find the (.) that is haphazardly placed.
Thanks for the help

 

[Fluff]

Why not just use the Search/Replace facility, either manually or in code?

 

[Guzzlr]

I tried that.
Find (.) replace with (blank)
It coming back that it could not find anything...

 

[Fluff]

Did you have "Match entire cell contents" checked when you tried?
If so uncheck it

 

[Guzzlr]

I was trying just the one column of "C". it found all (.) when the entire sheet was selected. I suppose that will work, I just wanted to find/replace the column C

 

[Fluff]

You should be able to just select col C & do it

 

[Guzzlr]

You should be able to just select col C & do it

That's what I've always done in the past. However, when I do it here, it says nothing is found. However, selecting the entire sheet, it does find the (.) and replace with a blank
Thanks for the help

 

[Fluff]

You're welcome & thanks for the feedback