macro to change column to keep only last 5 characters

  • Thread starter Thread starter S Himmelrich
  • Start date Start date
S

S Himmelrich

I'm not sure how I can use left or right or trim on this, but any
suggestions?
 
Formula method.

Assuming data in column A, in B1 enter =RIGHT(A1,5) and double-click fill
handle to copy down.

Macro method. You choose the activecell.

Sub trimmit()
Dim rng As Range
Set rng = Range(ActiveCell, Cells(Rows.Count, ActiveCell.Column).End(xlUp))
For Each cell In rng
cell.Value = Right(cell.Value, 5)
Next
End Sub


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Macro for comparing columns and highlighting matching/differences 14
Moving a bunch of data 1
chop off last 5 characters of a string 9
Can't Explain N/A in Vlookup 2
Special Text to Column question 3
Spam 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
why won't text-to-columns work here? 6

Back
Top