How to insert newlines in a cell

rwallenstein

New Member
Joined
Sep 24, 2002
Messages
4
I have a text file with a column that contains newlines. However, when I copy it into a spreadsheet, the newlines become rows. I want the newlines to act like Alt-Enter. Is there a sequence of characters that I can use in my text file to act as Alt-Enter when copying it to the spreadsheet?
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Sir Vili

Board Regular
Joined
Jul 11, 2002
Messages
148
Hi rwallenstein.

If I understand correctly Your Problem, do this:

1.

Supposing that You are coping text to column B, make it first wider (start with 70,0)

2. Then paste text to B3.

3. Choose from Menu: Format -> Cells -> select from dialog You got page Alignment. Find WRAP TEXT and mark it.

Now Your text will be wrapped. You can test with changing column width and sometimes also row height. If You are coping more text for example to B4, You can use Format Painter to get same format from B3 to B4.

Hope this was You needed.

BRGDS Sir Vili.
 

rwallenstein

New Member
Joined
Sep 24, 2002
Messages
4
Hi,

That is not the problem.

A line of text in the text file which is separated by tabs looks like:

field1 <tab> field2 <tab> blah1 blah2 blah3

I want the blahs to be vertical in the cell:

A B C
1 field1 field2 blah1
blah2
blah3

What sequence of characters can I put between the blahs to accomplish this?

Thanks again.

Richard

PS I sent a previous reply but I wasn't
logged in so it wasn't sent I think.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,224
Messages
5,594,914
Members
413,952
Latest member
JGer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top