Posted to microsoft.public.excel.misc

christi

external usenet poster

Posts: 30

Concatenating & Formatting

I am concatenating several cells.

I would like for each cell I am concatenating to start a new line within my
final cell.

If I am just typing in a cell I can do ALT and Enter to start a new line.
How can I put that in my formula to make the concatenate do that?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
concatenating	Yosh	Excel Discussion (Misc queries)	7	February 7th 07 09:03 PM
retain formatting when concatenating	rjhf	Excel Worksheet Functions	2	May 3rd 06 06:31 PM
concatenating and formatting area code and phone number columns	sherri	Excel Worksheet Functions	4	September 1st 05 09:59 PM
Concatenating	Metalteck	New Users to Excel	10	May 4th 05 01:01 AM
keep $ formatting when concatenating	danielo	Excel Discussion (Misc queries)	6	February 7th 05 10:37 PM

All times are GMT +1. The time now is 09:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us