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

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

Thanks GS,

I just put that code in the vba editor and ran it. It worked except it only
worked on five cells and then stopped. I need it to work on all cells in the
column

Also, any easy way to delete those first 5 numbers from the original column
they were in (A)?

Thanks a ton!
CW

"Gary''s Student" wrote:

> 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

Ok, I'm dumb.

I can change the upper value for I to get any number of columns....

CW

"Cheese_whiz" wrote:

> Thanks GS,
>
> I just put that code in the vba editor and ran it. It worked except it only
> worked on five cells and then stopped. I need it to work on all cells in the
> column
>
> Also, any easy way to delete those first 5 numbers from the original column
> they were in (A)?
>
> Thanks a ton!
> CW
>
> "Gary''s Student" wrote:
>
> > 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

You are not dumb at all !

Commend yourself for taking the initiatve and coming up with the
modification on your own.

Have a pleasant weekend
--
Gary's Student


"Cheese_whiz" wrote:

> Ok, I'm dumb.
>
> I can change the upper value for I to get any number of columns....
>
> CW
>
> "Cheese_whiz" wrote:
>
> > Thanks GS,
> >
> > I just put that code in the vba editor and ran it. It worked except it only
> > worked on five cells and then stopped. I need it to work on all cells in the
> > column
> >
> > Also, any easy way to delete those first 5 numbers from the original column
> > they were in (A)?
> >
> > Thanks a ton!
> > CW
> >
> > "Gary''s Student" wrote:
> >
> > > 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

Thanks again!

I got it to delete the five off the original column too. All set thanks to
your help!

CW

"Gary''s Student" wrote:

> You are not dumb at all !
>
> Commend yourself for taking the initiatve and coming up with the
> modification on your own.
>
> Have a pleasant weekend
> --
> Gary's Student
>
>
> "Cheese_whiz" wrote:
>
> > Ok, I'm dumb.
> >
> > I can change the upper value for I to get any number of columns....
> >
> > CW
> >
> > "Cheese_whiz" wrote:
> >
> > > Thanks GS,
> > >
> > > I just put that code in the vba editor and ran it. It worked except it only
> > > worked on five cells and then stopped. I need it to work on all cells in the
> > > column
> > >
> > > Also, any easy way to delete those first 5 numbers from the original column
> > > they were in (A)?
> > >
> > > Thanks a ton!
> > > CW
> > >
> > > "Gary''s Student" wrote:
> > >
> > > > 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