Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

copy/paste

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

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.
Thanks

Share: 

 

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.




Tagged: