I would like to find specific digits in a cell and replace it with a symbol or some text like "duplicate", not the whole cell only the duplicate characters in the cell.
I have one column with more then 2500 rows which contains contact numbers. Every cell contains more then one number. then i have a another column in which i have the numbers that i want to be deleted from the first column.
I am placing the example so everybody can get an idea of what i want.
<tbody>
</tbody>
<tbody>
</tbody>
I am new to fourms, Could not find the attachment button to attach excel file, so made a table in the post. Help in this regard is highly appreciated. Thanks
I have one column with more then 2500 rows which contains contact numbers. Every cell contains more then one number. then i have a another column in which i have the numbers that i want to be deleted from the first column.
I am placing the example so everybody can get an idea of what i want.
Column 1 looking for duplicates in this one | Column 2 Numbers to find from first column and replace with symbol |
<tbody>
</tbody>
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
I am new to fourms, Could not find the attachment button to attach excel file, so made a table in the post. Help in this regard is highly appreciated. Thanks
Last edited by a moderator: