How to increase a number from a text and number combine cell ?

How to increase a number from a text and number combine cell ?

 

In column A I have several kinds of codes which are duplicate. Now I want to make anothere code usith those coded by adding -1, -2 so on, without adding any extra column. And new code will uniqe in only first row of duplicate code of A column.

 

Column A Column B

 

2UK7QTOC 2UK7QTOC-1

2UK7QTOC

6DEITIWC 6DEITIWC-2

6DEITIWC

6DEITIWC

8AEITIWC 8AEITIWC-3

8AEITIWC

8AEITIWC

By: Bharat Rangari

Leave a Reply

Your email address will not be published. Required fields are marked *