Autofill alphanumeric prefix in Excel
 

I need to add a prefix that starts with alpha and ends in 1,2,3 etc. I have figured out how to add the prefix, but it remains on number 1.

Thanks

Autofill alphanumeric prefix in Excel
 

Hi,

Am Wed, 16 Apr 2014 10:53:35 -0700 (PDT) schrieb :

I need to add a prefix that starts with alpha and ends in 1,2,3 etc. I have figured out how to add the prefix, but it remains on number 1.

in row 1:
="a"&ROW()

If you start from another row then
="a"&ROW(A1)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Autofill alphanumeric prefix in Excel
 

On Wednesday, April 16, 2014 12:53:35 PM UTC-5, wrote:
I need to add a prefix that starts with alpha and ends in 1,2,3 etc. I have figured out how to add the prefix, but it remains on number 1. Thanks


Claus - Thank you for your answer. It works fabulously! :)