How do I had a suffix to a cell i.e. -1,-2,-3?

C

Chip Pearson

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]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting full Names from 1 cell to 2 5
Sort by number only in cell 2
Excel---how do i automate adding a suffix to text? 1
Using a macro in excel to hyperlink files 1
How do I format a cell value to show kg? 2
Adding more information to a column of cells? 2
Compare text in cell to custom text format?? 1
Transfering of data from 1 worksheet to another 1

Top