Skip to main content

How to Copy Paste Formated Texts from a Word Table to Excel without Formating problem

Performing copy paste from an MS Word file's table or from other formatted text, it is always an irritating task that we normally face when we paste the copied texts from these places

I want to clarify it with an example. Suppose a table cell is copied from a table of ms word file; in which there are two lines of the texts in a cell of the table. It is pasted in a cell of an excel file, and then it has been noticed that the texts spreads over two cells in two individual rows. It can be seen in the image given below. Whatever we try, it becomes a tail of a dog that never attains a pattern we want.

See this table in the figure. Copy the texts and paste it in a cell of excel file, you will notice that the texts spread over two or more rows.

This problem has very simple solution; which we never try and think. Just before doing paste action press F2 function key to highlight the text entry cursor in the cell of the excel file. After that do paste the copied texts from the table cell. It simply attain its position as we type in the cell.

This trick is very useful for doing formatted texts' copy paste.

Only negative point of doing this activity is that we need to do the task for each cell. We can’t perform copy paste for whole of the texts in one single command.


Comments

Popular posts from this blog

How to Customize Blog Pager ( Newer Post Home Older Post )

To change the pager name we can do the following steps.
Step1: Click on Template> HTML > Jump to widget, blog1 Then expand this line.

As shown in the image.
Step 2:Do This.
Ctrl+F for <data:newerPageTitle/>
OR watch this line <data:newerPageTitle/> in the image as given below.and replace it with own name e.g. Newer Essay etc Step3: Similarly do this.
Ctrl+F for <data:olderPageTitle/>
and replace this by own text e.g. Older Essay etc.
Result of this edit: See the image given below ; which is obtained after edit.

How to add post Header in title bar of the website. Better Ranking in SE |Blogger|Blogspot

Very successful . After doing it my title . Before it the post title were not appearing in the title bar of my website. Also other advantage of this is that the site name was getting appering after post title in search result pages. See the location of the code highlighted. It will help you to find the location of the code pasting.Click to zoom it.


Title bar has got the title of the post when i click on any post link.
It  improved my site rank in search engine.
------------------------------------------------------------------------------------
My original title of free essay code
 <title><data:blog.pageTitle/></title>

------------------------------------------------------------------------------------
Edited code for better ranking in google SE

<b:if cond='data:blog.pageType == &quot;index&quot;'>
<title><data:blog.title/></title>
<b:else/>
<title><data:blog.pageName/> | <data:blog.title/></title>
</b:if&g…

Follow by Email