excel programming vba - Linking 2 cells with data

Hi Gurmit

What you would need to do is merge the two cells together, however, if you do this when both cells have data in them then not all the data is kept.

If you cut and paste the information from the second cell into the first cell, then select both cells and click on the merge button on the formatting toolbar (it is a white square with an 'a' and arrow pointing in either direction on it), this should allow you to merge (join) these two cells together and not lose any data in the process.

Amanda