Concatenation Question

Leonidas · Apr 14th, 2002, 11:04 PM

Hi-

Is it possible to concatenate two text strings with a line break in between (like hitting alt-enter)? Please advise.

Thanks,

Gil

Tom Urtis · Apr 14th, 2002, 11:39 PM

Yes it is, via formula or VBA.

If formula, try
=A1&CHAR(10)&A2
with the formula cell formatted for wrapped text.

If VBA, try something like
ActiveCell = [A1] & Chr(10) & [A2]

Any help?

Leonidas · Apr 15th, 2002, 04:08 PM

Thanks, Tom!

-Gil

Apr 14th, 2002, 11:39 PM	#2
Tom Urtis MrExcel MVP Join Date: Feb 2002 Location: San Francisco, California USA Posts: 10,388	Yes it is, via formula or VBA. If formula, try =A1&CHAR(10)&A2 with the formula cell formatted for wrapped text. If VBA, try something like ActiveCell = [A1] & Chr(10) & [A2] Any help? __________________ Tom Urtis Microsoft MVP - Excel

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

Apr 14th, 2002, 11:04 PM	#1
Leonidas New Member Join Date: Mar 2002 Location: Covina, Ca Posts: 5	Hi- Is it possible to concatenate two text strings with a line break in between (like hitting alt-enter)? Please advise. Thanks, Gil

Apr 15th, 2002, 04:08 PM	#3
Leonidas New Member Join Date: Mar 2002 Location: Covina, Ca Posts: 5	Thanks, Tom! -Gil