VBA To Create Suffix

**bilbo85** · 12-08-2015, 05:48 PM

Hi,

I have a column of references such as:

602
602
603
604
604
604

I need some VBA to add a letter on the end of each string to make each one unique. So the above should read:

602A
602B
603A
604A
604B
604C

There is always a different amount of references in column A so need VBA to automatically detect this and change each one. Once it gets to Z, it should carry on with AA, AB, AC, etc.

Thanks for your help.

**stnkynts** · 12-08-2015, 06:20 PM

This is assuming there is a header in column A. It will go to ZZ if neccessary.

Please Login or Register  to view this content.

**jindon** · 12-08-2015, 06:37 PM

This goes up to XFD for one item.

Please Login or Register  to view this content.

**Richard Buttrey** · 12-08-2015, 06:39 PM

Hi and welcome to the forum,

Is it vital to have a letter rather than a suffix like 602_1, 602_2, 603_1 ..etc.
It would be a doddle if that was permitted and no need for VBA.

**shg** · 12-08-2015, 08:29 PM

How about just a formula?

Row\Col	A	B	C
1	602	602A	B1: =A1 & SUBSTITUTE(ADDRESS(1, COUNTIF(A$1:A1, A1), 4), 1, "")
2	602	602B
3	603	603A
4	604	604A
5	604	604B
6	604	604C

VBA To Create Suffix

LinkBack

Thread Tools

Rate This Thread

Display

VBA To Create Suffix

Re: VBA To Create Suffix

Re: VBA To Create Suffix

Re: VBA To Create Suffix

Re: VBA To Create Suffix

Thread Information

Users Browsing this Thread

Similar Threads

Prefix and Suffix Help

Add suffix to Tab Name if it already exists

[SOLVED] Changing a positive or negative value based on the input's suffix, then removing suffix

question about suffix

Add Suffix & Prefix

[SOLVED] How do I had a suffix to a cell i.e. -1,-2,-3?

[SOLVED] I'd like to add a suffix...

Bookmarks

Bookmarks

Posting Permissions