Need help in adding prefix to each unique entries in cell

[shaikfazil]

Hi all,

I'm finding difficult to find add prefix to unique entries in the column.

For example:
82328331 is appearing 5 times in the column.
so i need to add
82328331A
82328331B
82328331C
82328331D
82328331E.

Likewise i need to add alphabetic series to all the values in the account number column. so i can create unique account number.

Thanks for your support. please find the attachment for your working.

[zbor]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-gene...s-in-cell.html

Thread Closed.