Excel break text string into 3 rows in same (merged) cell 1

[swtrader]

I have a report that has five columns. 4 of the columns contain minimal info (like a dollar amount). 1 of the columns, however, contains: CompanyName, IndName, IndTelcoNo.

I want this to 'split' and be centered on 3 different text rows within the cell....such as

ABC Co.
John Alexander
333-333-3333

rather than: ABC Co. John Alexander 333-333-3333

Is there a line break character or symbol I can insert into the string that will cause this to break this way?

Thanks.

 

[fumei]

Is there a line break character or symbol I can insert into the string that will cause this to break this way?"

Kind of.

ABC Co. <Alt-Enter>John Alexander<Alt-Enter> 333-333-3333

becomes

ABC Co.
John Alexander
333-333-3333

The centering comes from the format of the cell.

Gerry

 

[swtrader]

Exactly what I needed. Thanks.