Remove a specific character in a cell of numbers

Guzzlr

Well-known Member
Joined
Apr 20, 2009
Messages
759
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
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,320
Office Version
  1. 365
Platform
  1. Windows
Why not just use the Search/Replace facility, either manually or in code?
 

Guzzlr

Well-known Member
Joined
Apr 20, 2009
Messages
759
I tried that.
Find (.) replace with (blank)
It coming back that it could not find anything...
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,320
Office Version
  1. 365
Platform
  1. Windows
Did you have "Match entire cell contents" checked when you tried?
If so uncheck it
 

Guzzlr

Well-known Member
Joined
Apr 20, 2009
Messages
759

ADVERTISEMENT

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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,320
Office Version
  1. 365
Platform
  1. Windows
You should be able to just select col C & do it
 

Guzzlr

Well-known Member
Joined
Apr 20, 2009
Messages
759
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,320
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,114,367
Messages
5,547,499
Members
410,797
Latest member
mlfuson
Top