copy date from one column to another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

-D- - 21 Mar 2008 17:23 GMT

I want to copy data from one column to another column, but add the copied
value to existing data. The field I'm copying from contains dates. The
field I'm copying to contains text.

For example:

Before the copy:
Column A Column B
3/21/2008 Lorem Ipsum dolor...etc.

After copy:

Column B
Lorem Ipsum dolor...etc. Date in: 3/21/2008

How can I accomplish this?

Thanks for any help.
Regards.

Reply to this Message

Don Guillett - 21 Mar 2008 18:04 GMT

Sub addtocolb()
For Each c In Range("a2:a4")
c.Offset(, 1) = c.Offset(, 1) & _
" Date in: " & Format(c, "mm/dd/yyyy")
Next c
End Sub

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

>I want to copy data from one column to another column, but add the copied
>value to existing data. The field I'm copying from contains dates. The
[quoted text clipped - 15 lines]
> Thanks for any help.
> Regards.

Reply to this Message

Rate this thread: