Posted to microsoft.public.excel.programming

gcotterl[_2_] gcotterl[_2_] is offline

external usenet poster

Posts: 83

Carriage return in a cell

How can I replace each comma followed by a space with a carriage-
return?

For example, a cell contains:

COL-ACTN-TYPE, COL-ACTN-NBR, ET-AL-IND

I want:

COL-ACTN-TYPE
COL-ACTN-NBR
ET-AL-IND

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
Carriage return in cell	gcotterl[_2_]	Excel Programming	0	January 13th 11 12:57 AM
Carriage return in same cell without using alt-enter	charlie54933	Excel Worksheet Functions	11	February 1st 10 12:33 AM
Getting rid of carriage return in cell	James R	Excel Discussion (Misc queries)	4	September 8th 08 07:53 PM
Carriage return within a cell	Jon	Excel Discussion (Misc queries)	3	August 7th 07 06:56 AM
Carriage return in a cell	Jos Vens[_2_]	Excel Programming	2	November 25th 04 10:03 AM

All times are GMT +1. The time now is 06:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us