Merge two text cells

[UHsoccer]

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"

[Mark W.]

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 ]

[UHsoccer]

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?