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
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