Apache OpenOffice Community Forum

I want to place people's first and last names one above and below one another in one cell. Is this possible and how?

Such as: John Jones
         Mary Smith

revshowers wrote: ↑Wed Sep 18, 2024 8:12 pm I want to place people's first and last names one above and below one another in one cell.

Yes. To learn the procedure for your system read Help → OpenOffice Help → OpenOffice Calc → Index → Search term → breaks in cells.

However Calc works best when a cell only holds one piece of information. If you put multiple names in a cell you will find it difficult to analyze your data with Calc features and functions. For example, you will find it difficult to use a function to determine how many names the cell holds.

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know