I want to find duplicates in the list by using Conditional Formatting with a Countif function but I need to remove the periods (....) in front of each part number before I run the formatting and I don't want to have to go into each cell and remove them manually but don't know any other way to do it. Any suggestions? Thanks.
2007-01-09 08:37:23 · 3 answers · asked by David H 1 in Computers & Internet ➔ Software
Can't you just do a find and replace? Just look for "....." and replace with '.'.
2007-01-09 08:41:32 · answer #1 · answered by leaptad 6 · 0⤊ 1⤋
In the next column put this function (Assuming your list starts from A1),put this in B1:
=TRIM( SUBSTITUTE(A1, "." ," "))
And fill it down to the end of your list
This formula will replace every dor in your cell with a space, then remove them all
mail me any info
Enjoy my prodile, I am the VBAXLMan
2007-01-13 03:01:00 · answer #2 · answered by Anonymous · 0⤊ 0⤋
You can use a secondary Macro program such ASAP Utilities. It has a tool called "Advanced Charector Removal" where you can delet specific charectors.
2007-01-09 08:46:59 · answer #3 · answered by hdeanwhite 1 · 0⤊ 1⤋