Very simple in VBA:

Sub appnd()
For i = 1 To 5
Cells(i, "B").Value = Cells(i, "B").Value & Left(Cells(i, "A").Value, 5)
Next
End Sub

--
Gary's Student


"Cheese_whiz" wrote:

I'm trying to figure out how, in Excel, I'd cut the first five digits off the
numbers that appear in each cell of one column and then append those numbers
to the corresponding cells in another column.

Would that be a query of some sort, or done with vba? I'm more experienced
with Access than Excel.

Thanks in advance,
CW