[Solved] Multiple names vertically in one cell

Discuss the spreadsheet application
Locked
revshowers
Posts: 3
Joined: Thu Jan 14, 2021 12:19 am

[Solved] Multiple names vertically in one cell

Post by revshowers »

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
Last edited by MrProgrammer on Tue Sep 24, 2024 3:25 pm, edited 3 times in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
OpenOffice 4.1.8 on Windows 10
User avatar
MrProgrammer
Moderator
Posts: 5430
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Multiple names in one cell

Post by MrProgrammer »

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
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.7.8, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
revshowers
Posts: 3
Joined: Thu Jan 14, 2021 12:19 am

Re: Multiple names in one cell

Post by revshowers »

 Edit: problem solved thanks 
OpenOffice 4.1.8 on Windows 10
Locked