Cell Linebreak

[sarumitai]

I have a simple sheet with 4 columns and about 5,000 rows. I will b
making each row into a flashcard.

What I am having trouble with is aligning the back of the card. For th
front I just use '=C45 and then align center on both directions.

For the back I want to have the remaining 3 cells in a row wit
linebreaks. So it looks something like:


Cell A


Cell B

Cell C

All in one cell, preferably separated by linebreaks so when I print i
out the front of the flash card has one cell's contents and the bac
has three cell's contents. I can do everything except get line break
within a cell and I can do that using Alt+Enter, but I need a functio
or a chr() string or something to embed in code.

Hope that made sense. Thanks

 

[Dave Peterson]

Char(10)

will work in a formula:

=a1&char(10)&b1

(make sure the cell is set for wraptext.)