Excel: Inserting many Horizontal rows in same Cell

Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
Sign up Log in
14 replies · 2K views
WWGD
Science Advisor
Homework Helper
Messages
7,828
Reaction score
13,156
Hi all,
I have been trying unsuccessfully to figure out how to insert many horizontal rows into the same
cell in Excel: I have gone over many sites, asked people, all sorts of key combinations, without success.
Any ideas you know work, please?
Thanks.
 
Physics news on Phys.org
WWGD said:
I need to produce a doc for a client that requires content in different cells/rows be pasted into a single cell.
Text content, or a text version of the calculations for those cells? Multiple cell structures are not compatible with a single cell''s structure, AFAIK
 
berkeman said:
Text content, or a text version of the calculations for those cells? Multiple cell structures are not compatible with a single cell''s structure, AFAIK
No, say you have text content in cells , say, D4, D5, D6 , and you want all of this written into cell D9, as three horizontal rows, i.e., D9 will contain:

EDIT:
(content of)D4
(Content of)D5
(Content of)D6
within it; three horizontal text rows falling into cell D9 .

Say we have
D4: Today I went
D5: Downtown for a drink
D6 And I left at around 5.

And we want to end up with :
Today I went
Downtown for a drink
And I left at around 5

all in cell D9, or anyone other cell.
 
Can you make it a different column? Can you give an example? Shoud be pretty easy...
 
No comprendo

Can you post a PDF of your spreadsheet? Use PrimoPDF or another free PDF writer...
 
Ok, please see address on top : I would like address to fit in a single cell:

upload_2017-11-24_20-19-18.png
 

Attachments

  • upload_2017-11-24_20-19-18.png
    upload_2017-11-24_20-19-18.png
    81.7 KB · Views: 553
ummm...

maybe I'm not reading this right...

doesn't "alt + enter" get you there?

Or just put them in many vertical cells and then merge the cells at the end. (I used to hate merge cells back when I used excel a lot but every now and then you actually needed it.)
 
  • Like
Likes   Reactions: Asymptotic and berkeman
Thanks all,
In case anyone is interested, this worked
I had the text written in a Word document, copied it there, then pasted it into : "Cell Indicator":

upload_2017-11-24_20-51-34.png


i.e., where the "fx" is.
 

Attachments

  • upload_2017-11-24_20-51-34.png
    upload_2017-11-24_20-51-34.png
    42.8 KB · Views: 743
  • Like
Likes   Reactions: Asymptotic and berkeman
Another approach is to set up a cell to concatenate text contained in source columns like so.
Caveat: I'm using LibreOffice Calc; Excel formulas can be somewhat different.

In this example cells A1 through E1 contain elements of the postal address, and cell F2 contains the formula.
  • ASC(cell) returns the specified cell's text value.
  • & is used to tie individual text strings together.
  • CHAR(10) is the ASCII code value for LF (line feed/new line). This is what the Alt-Enter key combo does.

Combine_text1.jpg
To separate "City" and "State" fields with a comma, substitute a comma for the appropriate line feed.
Combine_text2.jpg
 

Attachments

  • Combine_text1.jpg
    Combine_text1.jpg
    16.4 KB · Views: 983
  • Combine_text2.jpg
    Combine_text2.jpg
    24.3 KB · Views: 996
  • Like
Likes   Reactions: WWGD
Asymptotic said:
Another approach is to set up a cell to concatenate text contained in source columns like so.
Caveat: I'm using LibreOffice Calc; Excel formulas can be somewhat different.

In this example cells A1 through E1 contain elements of the postal address, and cell F2 contains the formula.
  • ASC(cell) returns the specified cell's text value.
  • & is used to tie individual text strings together.
  • CHAR(10) is the ASCII code value for LF (line feed/new line). This is what the Alt-Enter key combo does.

View attachment 215684To separate "City" and "State" fields with a comma, substitute a comma for the appropriate line feed.
View attachment 215685
Excellent, man, thanks!. I would even suggest a new subforum for Excel, given how many people use it , and how versatile it can be.
 
  • Like
Likes   Reactions: Bystander
WWGD said:
Excellent, man, thanks!. I would even suggest a new subforum for Excel, given how many people use it , and how versatile it can be.
It was a pleasure. Don't know that Excel rates a sub-forum, but perhaps rather a sticky thread for sharing tips on how Excel and other spreadsheets can be used in technical and scientific applications.