| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add a prefix to a column of numbers in an excel document? | Excel Worksheet Functions | |||
| Autofill data based on an assigned code/prefix | Excel Worksheet Functions | |||
| Format alphanumeric field in Excel | Excel Programming | |||
| How do I automatically add a prefix to cell value in Excel? | Excel Discussion (Misc queries) | |||
| Sorting Alphanumeric data in Excel 2003 | Setting up and Configuration of Excel | |||
Linear Mode
