Merge two text cells

UHsoccer · May 7th, 2002, 08:17 AM

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. · May 7th, 2002, 08:23 AM

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 · May 7th, 2002, 08:25 AM

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 08:17 AM	#1
UHsoccer Board Regular Join Date: Apr 2002 Location: Detroit Posts: 792	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"

May 7th, 2002, 08:23 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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 ]

May 7th, 2002, 08:25 AM	#3
UHsoccer Board Regular Join Date: Apr 2002 Location: Detroit Posts: 792	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?