cut and paste 5 numbers from one col to another for entire column
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
|