Microsoft Office Forums - View Single Post - [Solved] I would like a function to add sequential numbers to a class number/name

Thread: [Solved] I would like a function to add sequential numbers to a class number/name

View Single Post

Old

01-16-2016, 09:54 AM

Kevin@Radstock Kevin@Radstock is offline

Kevin@Radstock is offline

Kevin@Radstock uses Windows 10

Windows 10 Kevin@Radstock uses Office 2016

Kevin@Radstock uses Office 2016

Office 2016

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

Default

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

Reply With Quote