Soft Returns

[Guest]

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

 

[Frank Kabel]

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

and format this cell with word wrap

 

[Gord Dibben]

Typo patrol<g>

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

Alternative if all items are space de-limited.

Select all cells and Edit>Replace

what: <space>
with: ALT + 0010

Replace all.

Set cells to Wrap-text and Autofit the rows.

Gord Dibben Excel MVP

 

[Frank Kabel]

Hi Gord

Typo patrol<g>

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

<vbg> good catch

Frank