I would like a function to add sequential numbers to a class number/name

		Microsoft Office Forums > Microsoft Excel > Excel
I would like a function to add sequential numbers to a class number/name

01-16-2016, 09:54 AM

Kevin@Radstock Kevin@Radstock is offline

Windows 10 I would like a function to add sequential numbers to a class number/name

Office 2016

Office 365

Join Date: Feb 2012

Posts: 94

As you have not posted a sample sheet. If those ABCD1234 in A1:A3, in B1 use:
"=A1&"-"&ROW()" & copy down.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
wildcard search and add (not replace) sequential numbers in front	equalizer88	Word VBA	4	05-07-2016 08:04 PM
Excel simplify formula - array of sequential numbers	Wries	Excel Programming	1	05-12-2014 08:32 AM
Creating a TOC with sequential letters instead of page numbers at the right margin	shansen	Word	1	03-11-2014 12:43 PM
Sequential Numbering on Tickets Multiple number Sequences	skitchen	Word	2	10-01-2013 06:41 AM
Labeling sequential forms with a unique number	krau0231	Word	1	10-18-2012 03:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:26 AM.