How do I had a suffix to a cell i.e. -1,-2,-3?
C Chip Pearson Jul 12, 2005 #2 You need VBA code to do this. Sub AAA() Dim Rng As Range Dim N As Integer: N = 1 For Each Rng In Range("A1:A5") ' change range as needed Rng.Value = Rng.Text & "-" & Format(N, "0") N = N + 1 Next Rng End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "controller_woman" <[email protected]> wrote in message news:[email protected]...
You need VBA code to do this. Sub AAA() Dim Rng As Range Dim N As Integer: N = 1 For Each Rng In Range("A1:A5") ' change range as needed Rng.Value = Rng.Text & "-" & Format(N, "0") N = N + 1 Next Rng End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "controller_woman" <[email protected]> wrote in message news:[email protected]...
