Macros

S

Sanjeev

How do i create a macro to join 2 cell and the result to come in the third
cell Request for help since i need to add to cell for 300 rows
 
B

Barb Reinhardt

You don't need to have a macro to do this, you can concatenate the data
together.

Let's say you want to concatenate A1 and B1 with a space between them and
put it in C1.

A1 = John
B1 = Smith

C1 = A1&" "&B1
 
V

vezerid

Sanjeev,
you are speaking of a macro, but this is probably just formula job.
If you want numeric sum, then in C1 you enter =A1+B1. You can then copy
the formula down.
If you mean that you want the text of the two cells joined next to each
other (concatenated) then use =A1&B1 instead.

HTH
Kostis Vezerides
 
Top