Excel: Inserting many Horizontal rows in same Cell

[WWGD]

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.

 

[berkeman]

LOL. Why?

 

[WWGD]

LOL. Why?

I need to produce a doc for a client that requires content in different cells/rows be pasted into a single cell.

 

[berkeman]

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

 

[WWGD]

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.

 

[berkeman]

Can you make it a different column? Can you give an example? Shoud be pretty easy...

 

[WWGD]

Can you make it a different column? Can you give an example? Shoud be pretty easy...

Sorry, just edited , please see above.

 

[berkeman]

No comprendo

Can you post a PDF of your spreadsheet? Use PrimoPDF or another free PDF writer...

 

[WWGD]

Ok, please see address on top : I would like address to fit in a single cell:

 

[WWGD]

So : Safety Lock
1713 Second Avenue
New York...All fitting in a single cell in Excel.

 

[StoneTemplePython]

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.)

 

[WWGD]

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":

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

 

[Asymptotic]

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.

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

 

[WWGD]

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.

 

[Asymptotic]

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.