Soft Returns

Hi,

I've got a column of data that has multiple values entered
into the cells (derived from another formula) eg cell A2
has List Item 1 List Item 2 List Item 4.

There can be any number of items and they are not a set
length.

Can I automatically put soft returns (Similar to pressing
Alt + Enter) in between the values so that the cell looks
like:

List Item 1
List Item 2
List Item 4

I could easily put a separator into the cell.

Hope someone has an idea as this is driving me insane.

Cheers

John

Hi
try in your formula
="Item1" & CHAR(10= & "Item2"

and format this cell with word wrap


--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
Hi,

I've got a column of data that has multiple values entered
into the cells (derived from another formula) eg cell A2
has List Item 1 List Item 2 List Item 4.

There can be any number of items and they are not a set
length.

Can I automatically put soft returns (Similar to pressing
Alt + Enter) in between the values so that the cell looks
like:

List Item 1
List Item 2
List Item 4

I could easily put a separator into the cell.

Hope someone has an idea as this is driving me insane.

Cheers

John

Typo patrolg

="Item1" & CHAR(10) & "Item2"

Alternative if all items are space de-limited.

Select all cells and EditReplace

what: space
with: ALT + 0010

Replace all.

Set cells to Wrap-text and Autofit the rows.

Gord Dibben Excel MVP

On Mon, 6 Sep 2004 15:13:08 +0200, "Frank Kabel"
wrote:

Hi
try in your formula
="Item1" & CHAR(10= & "Item2"

and format this cell with word wrap

Hi Gord

Typo patrolg

="Item1" & CHAR(10) & "Item2"

vbg good catch

Frank