Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste from word to excel, into one cell.
Trying to paste a few lines of text from Word into a single cell in Excel and
it pastes onto several rows. How do I make it paste into a single cell ? thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste from word to excel, into one cell.
Copy the text in Word.
Select the cell in Excel Click on the formula bar and paste in the formula bar. -- Gary's Student "tonym" wrote: Trying to paste a few lines of text from Word into a single cell in Excel and it pastes onto several rows. How do I make it paste into a single cell ? thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste from word to excel, into one cell.
Saved from a previous post:
If your cells in your word table contain paragraph mark or linebreak characters, then excel will bring them over as separate cells. One way around it is to convert those paragraph marks & linebreaks to unique characters, then copy|paste and then convert them back to linefeeds. I like this technique (inside a copy of the word file): Select your table. Edit|replace|Special (show More if required) Find what: (paragraph mark under Special button) replace with: $$$$$ (if $$$$$ doesn't appear in the table) replace all Same thing with Manual Line break (from under Special). Now copy the table into Excel. Edit|Replace Replace what: $$$$$ Replace with: ctrl-j replace all. Don't forget to close the word document without saving (or hit undo as many times as necessary). tonym wrote: Trying to paste a few lines of text from Word into a single cell in Excel and it pastes onto several rows. How do I make it paste into a single cell ? thanks -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste from word to excel, into one cell.
Hi Tony,
Just to add to Gary's post you may want to paste into Notepad first and then copy and paste from Notepad to the formula bar. This will get rid of all the excess baggage that word tacks on. HTH Martin |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste from word to excel, into one cell.
Hello, MartinW!
You wrote on Tue, 26 Sep 2006 23:27:12 +1000: M Just to add to Gary's post you may want to paste into M Notepad first and then copy and paste from Notepad to the M formula bar. M This will get rid of all the excess baggage that word tacks M on. The PureText free utility: http://www.stevemiller.net/puretext/ is a faster way to deal with this since it does not require opening other programs. Incidentally a very wry comment, I have been using Excel for longer than I care to admit but I had not noticed that the space was called the "Formula Bar" :-) I now know the annotation appears if you look but I guess I've never bothered. I just mentally regarded it as the "Entry Space". James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste from word to excel, into one cell.
That seems to work just fine. Thanks
"Gary''s Student" wrote: Copy the text in Word. Select the cell in Excel Click on the formula bar and paste in the formula bar. -- Gary's Student "tonym" wrote: Trying to paste a few lines of text from Word into a single cell in Excel and it pastes onto several rows. How do I make it paste into a single cell ? thanks |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste from word to excel, into one cell.
I wanted eaxctly the opposite.
I had been typing a while and upon completition decided to spell check manually. then noticed this was to long accross the page. So I tried to set the cursor behind where i want to wrap down to the next line. Like you would in Word. It deleted everything and left no way to undo or redo. I am still steaming. it was a perfect course of typing. I just wanted it to be like a webpage RIGHT IN FRONT OF ME not so far right that I was in the quad Z column. and i have now been reading these forums for an hour and have found nothing similar to tell me why what the help instructions say, don't work. -- screw the profile I don''''''''t want a forum buddy I am here to look for solutions not more of the same frigging stress i already have cause your freakin program doesn''''''''t do what you say it doe "Dave Peterson" wrote: Saved from a previous post: If your cells in your word table contain paragraph mark or linebreak characters, then excel will bring them over as separate cells. One way around it is to convert those paragraph marks & linebreaks to unique characters, then copy|paste and then convert them back to linefeeds. I like this technique (inside a copy of the word file): Select your table. Edit|replace|Special (show More if required) Find what: (paragraph mark under Special button) replace with: $$$$$ (if $$$$$ doesn't appear in the table) replace all Same thing with Manual Line break (from under Special). Now copy the table into Excel. Edit|Replace Replace what: $$$$$ Replace with: ctrl-j replace all. Don't forget to close the word document without saving (or hit undo as many times as necessary). tonym wrote: Trying to paste a few lines of text from Word into a single cell in Excel and it pastes onto several rows. How do I make it paste into a single cell ? thanks -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste from word to excel, into one cell.
I'm not sure I understand your question.
But you can wrap text in a cell by formatting the cell: format|cells|alignment tab|check wrap text. You can also force a new line within the cell by hitting alt-enter. screwtheprofile wrote: I wanted eaxctly the opposite. I had been typing a while and upon completition decided to spell check manually. then noticed this was to long accross the page. So I tried to set the cursor behind where i want to wrap down to the next line. Like you would in Word. It deleted everything and left no way to undo or redo. I am still steaming. it was a perfect course of typing. I just wanted it to be like a webpage RIGHT IN FRONT OF ME not so far right that I was in the quad Z column. and i have now been reading these forums for an hour and have found nothing similar to tell me why what the help instructions say, don't work. -- screw the profile I don''''''''t want a forum buddy I am here to look for solutions not more of the same frigging stress i already have cause your freakin program doesn''''''''t do what you say it doe "Dave Peterson" wrote: Saved from a previous post: If your cells in your word table contain paragraph mark or linebreak characters, then excel will bring them over as separate cells. One way around it is to convert those paragraph marks & linebreaks to unique characters, then copy|paste and then convert them back to linefeeds. I like this technique (inside a copy of the word file): Select your table. Edit|replace|Special (show More if required) Find what: (paragraph mark under Special button) replace with: $$$$$ (if $$$$$ doesn't appear in the table) replace all Same thing with Manual Line break (from under Special). Now copy the table into Excel. Edit|Replace Replace what: $$$$$ Replace with: ctrl-j replace all. Don't forget to close the word document without saving (or hit undo as many times as necessary). tonym wrote: Trying to paste a few lines of text from Word into a single cell in Excel and it pastes onto several rows. How do I make it paste into a single cell ? thanks -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I paste 429 character Excel cell in MS Word ? | Excel Discussion (Misc queries) | |||
Paste from EXCEL into WORD when reduced | Excel Discussion (Misc queries) | |||
Copy and paste Excel chart in Word -- font compresses | Charts and Charting in Excel | |||
Excel 2003 Word Wrap Problem within cell | Excel Discussion (Misc queries) | |||
Paste table from excel to word | Excel Worksheet Functions |