Thread: How do I add sequential numbers to existing data in excel?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Slinky Slinky is offline
external usenet poster
  
Posts: 4
Default How do I add sequential numbers to existing data in excel?
I need to sequentially number existing data.
For example, the existing data is:

(A1) 2x4-c_
(A2) 2x4-b_
(A3) 3x5-c_
(A4) 3x5-b_

The desired end result is:

(A1) 2x4-c_00001
(A2) 2x4-b_00002
(A3) 3x5-c_00003
(A4) 3x5-b_00004

I need a formula/macro to append the sequential numbers to lists of data
that are 200-1000 rows long. Any ideas?
Reply With QuoteReply With Quote