If by "merge" you mean "concatenate" use the concatenation operator (&) as follows...
=A1&B1
[ This Message was edited by: Mark W. on 2002-05-07 07:24 ]
Try to merge (with text wrap) two (adjacent) cells. Eventually need to do this for nearly the an entire column of data
Response "Selection contains multiple data values. Merging into one cell will keep upper-left most data value"
If by "merge" you mean "concatenate" use the concatenation operator (&) as follows...
=A1&B1
[ This Message was edited by: Mark W. on 2002-05-07 07:24 ]
Thanks, two questions
Where in the menus can I do "concatenate" vs merge?
How to do it in VB from the first to the last used cell?
Like this thread? Share it with others