[[email protected]]

Hi all!

I am trying to make a list of numbers plus a letter:
00000001A
00000002A
00000003A
.......etc

I have tried to put the number in the first column and the letter in the second and use the formula =A1&""&B1, but its not working.

Any suggestions?

[Claus Busch]

Hi,

Am Wed, 12 Feb 2014 10:28:21 -0800 (PST) schrieb :

I am trying to make a list of numbers plus a letter:
00000001A
00000002A
00000003A

in A1 try:
=TEXT(ROW(A1),"00000000")&"A"
and copy down


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

[Claus Busch]

Hi,

Am Wed, 12 Feb 2014 19:33:43 +0100 schrieb Claus Busch:

=TEXT(ROW(A1),"00000000")&"A"

or try:
=TEXT(ROW(A1),"00000000A")


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

[[email protected]]

My file doesn't seem to recognize that what I am entering is a function.

I am starting at 00003600A, and when I put in =TEXT(ROW(A3600),"00000000A") it is just entered into the cell as text.

[Claus Busch]

Hi,

Am Wed, 12 Feb 2014 10:56:18 -0800 (PST) schrieb :

I am starting at 00003600A, and when I put in =TEXT(ROW(A3600),"00000000A") it is just entered into the cell as text.

format your cells as General. If it doesn't work at once select the
column and run TextToColumns = Fixed width = Finish


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2