Hello all,
I have about 10K Cells with part numbers that have commas, periods, dashes, etc is there a way to have the cell to its imediate right have the same text minus all the characters mentioned above?
Example:
12-1244 to 121244
mpr/13 to mpr13

Thanks for any help
Darrell