Number Suffixes

**Louismk** · 01-25-2013, 12:06 PM

Hello, I am trying to find a quick way to add numbers (as text) to a sting of numbers should the same number be repeated multiple times in a sequence. The problem that I am running into is this:

Say I have cells that repeat the same number as shown below:

123456789
123456789
123456789
123456789

What I need is these numbers to read

12345678901
12345678902
12345678903
12345678904

... and so on

I am able to do this in an IF statement but the most I can get is for all the numbers in the sequence to end with "01" and I need them to ascend until the sequence ends.

Please help!!

**Fotis1991** · 01-25-2013, 12:13 PM

Assuming that your data starts in g2 and down, try this in H2 and copy down.

=G2&ROW(A1)

**Marcol** · 01-25-2013, 12:14 PM

Try this, Drag Down as required.

Formula:

=IF(A1="","",A1&TEXT(COUNTIF(A$1:A1,A1),"00"))

**bebo021999** · 01-25-2013, 12:18 PM

Assuming your list of numbers starting from A1
In B1, try:
=A1&TEXT(COUNTIF($A$1:A1,A1),"00")
Copy down.
Copy and paste special/value to A column, if you want

**MarvinP** · 01-25-2013, 12:31 PM

Hi Guys,

Try this answer with a helper column and no need to convert to a text string.

**Marcol** · 01-25-2013, 01:10 PM

Originally Posted by MarvinP

Hi Guys,

Try this answer with a helper column and no need to convert to a text string.

Or numeric without a helper

Formula:

=IF(A1="","",A1*10^2+COUNTIF(A$1:A1,A1))

Number Suffixes

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Number Suffixes

Re: Number Suffixes

Re: Number Suffixes

Re: Number Suffixes

Re: Number Suffixes

Re: Number Suffixes

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions