File numbers

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I have about 10,000 files that need to be numbered 1 after the other. The
sequence is MCV-337F MCV-338F etc, where only the number changes, not the
letters. If it were just numbers I could use the =sum(A1+1) but it does not
work with the letters. Is there a way to do this?

Bill
 
In Cell A1 (for example), put "MCV-"
In A2: "F"
In B1: "=$A$1&ROW()&$A$2"

Fill down 999 rows

Of course you could use "=MCV-"&ROW()&"F", but this is easier if you want to
change the text part.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
"Bill"
I do not understand what you want to do,
but I hope next Macro might give you an idea!

This macro generates your strings into the range of (A1:A10000)
that you wanted.

*******************************
Try This MacroMCV337F Macro;
*******************************
Sub MacroMCV337F()
'
' MacroMCV337F Macro
' Macro 2004/6/19 by Yujiro
'
'
Range("A1").Select
ActiveCell.FormulaR1C1 = "MCV-337F"
Range("A1").Select
Selection.AutoFill Destination:=Range("A1:A10000"), Type:=xlFillDefault
Range("A10001").Select
End Sub
 
Back
Top