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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

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
6,005
Office Version
  1. 365
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,047
Messages
5,857,025
Members
431,847
Latest member
mrKY

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