Capxc

If you wanted a little bit of Visual basic code, you could achieve the same
result without any helper columns with the following:

Sub TrimFirstSix()
For Each TrimCell In Range("D1:D500")
TrimCell.Formula = Right(TrimCell, Len(TrimCell) - 6)
Next
End Sub

If you wanted to select a range of cells and trim THOSE, replace the second
line with: For Each TrimCell In selection

Regards

Pete


"capxc" wrote:

How to delete fist 6 digit of all contents in a column?
Column has 13 digits(alpha-numeric) and we need to delete the first 6 of
each cell in the same column (D1 to D500)
--
capxc