Multiline Data in a Cell

jake8008

New Member
Joined
Sep 29, 2006
Messages
5
I need to know how I can paste multiline data into a single cell. Excel always wants to break it down into several rows.

I need to solve this problem asap.
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

xapie128

Board Regular
Joined
Aug 26, 2006
Messages
82
What type of data is it? Text?
If text, select the cell then format it by checking Wrap text (in the Alignment tab).
 

jake8008

New Member
Joined
Sep 29, 2006
Messages
5
It's code, part text and part numbers. The code should just be treated as data.

Word wrap hasn't worked.
 

xapie128

Board Regular
Joined
Aug 26, 2006
Messages
82
Post a sample.
Are you pasting it into the cell or into the formula bar?
 

jake8008

New Member
Joined
Sep 29, 2006
Messages
5

ADVERTISEMENT

SAMPLE:

script type="text/javascript"
google_ad_client = "pub-8084076344898546";
google_ad_width = 120;
google_ad_height = 600;
google_ad_format = "120x600_as";
google_ad_type = "text";
google_ad_channel ="";
google_color_border = "FFFFFF";
google_color_bg = "FFFFFF";
google_color_link = "000080";
google_color_url = "FFFFFF";
google_color_text = "000000";
//--></script>
script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"
/script
script language='javascript' src='http://www.9clouds.com/astracker/ast.php'></script


I pasted into the cell.
 

jake8008

New Member
Joined
Sep 29, 2006
Messages
5
well, the sample made Google ads show on this page because the code is google adsense code.


Ok, now i've edited parts of the code to show you the sample
 

xapie128

Board Regular
Joined
Aug 26, 2006
Messages
82

ADVERTISEMENT

I see, you are trying to paste Java script into a cell.
Using the standard copy/paste method you are always going to have some sort of table pasted. I am not sure exactly what you are trying to accomplish, but I'm not familiar enough with a Java/Excel transfer to offer much assistance. I'll let other, more experienced Excel masters chime in here.
 

jake8008

New Member
Joined
Sep 29, 2006
Messages
5
I need to enter this code in many cells, then upload to a website. So I need the code to be entered into the cell just as listed above.
 

starl

Administrator
Joined
Aug 16, 2002
Messages
5,974
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. MacOS
If you want to put all the lines into a single cell, have your cursor IN THE CELL before doing the paste.
To put your cursor in the cell, double-click on the cell, then do your paste. It will place all the lines within the single cell. If you just select a cell, then it will paste each line in its own row.
 

Watch MrExcel Video

Forum statistics

Threads
1,133,452
Messages
5,658,857
Members
418,473
Latest member
shaztastic73

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