MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds


  Asked By: Clifford    Date: Oct 16    Category: MS Office    Views: 567

I have a huge excel file with columns containing alphanumeric values.
What I would like to do is for example:
In one row, to copy the values of 2 adjacent cells and paste them in
the following empty cell.
I am new in using macros in excel visual basic and haven't been able
to perform that task yet.

Would someone help me, that would be very helpful.



1 Answer Found

Answer #1    Answered By: Barabas Cohen     Answered On: Oct 16

Copy/paste doesn't do this sort of combination of information.

But you can easily do it in VBA. If A1 has "Jack" and B1 has "Jill" ...

Range("C1").Value = Range("A1").Value & " and " & Range("B1").Value

Didn't find what you were looking for? Find more on copy/paste Or get search suggestion and latest updates.