Thread
:
Autofill alphanumeric prefix in Excel
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
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
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch