if this doesnt work on your sheet, it because format cell number change format cell number become plain text, and its work p.s it impact to your formula, if you change the cell that use to calculation in other sheet / cell
I figured it out way simpler just put a 0 into a cell then pull that little blue square in the lower right corner itll copy the values for the cells all below
@@henryhachihung I installed special plugin for this in google sheet, cause idk why reg exp doesn't work for me. Called "Remove duplicates" and have bigger functionality that in name.