Thread: [Solved] I would like a function to add sequential numbers to a class number/name
View Single Post
 
Old 01-19-2016, 12:29 PM
Highlander01 Highlander01 is offline Windows 10 Office 2016
Novice
  
Join Date: Jan 2016
Location: Portsmouth, England
Posts: 18
Highlander01 is on a distinguished road
Default
Quote:
Originally Posted by Kevin@Radstock View Post
As you have not posted a sample sheet. If those ABCD1234 in A1:A3, in B1 use:
"=A1&"-"&ROW()" & copy down.
Excellent!
Thank you very much Kevin, greatly appreciated.

In addition - Is there a way to adapt the formula so that the cells in column B will remain blank until there is something (ABCD1234) in column A If the formula was already in place?

Regards

G
Reply With Quote