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

My all Chrome Bookmarks of Blogger Example

These bolgger tutorial sites are very imprtant.

http://www.bloggersentral.com/2009/11/blogger-auto-read-more-with-thumbnail.html
http://bloggerstop.net/2010/02/add-forum-to-your-bloggerblogspot-blog.html
http://www.eblogtemplates.com/blogger-ad-code-converter/
http://www.bloggertipsandtricks.com/2010/02/create-sub-domain-with-custom-domain.html#subdomain
http://www.smartgb.com/features.php
http://tips-for-new-bloggers.blogspot.in/2007/02/add-page-element-to-blogger-header-and.html
http://kluwanone.blogspot.in/2010/01/how-to-redirect-blogger-post-to-another.html
http://www.betatemplates.com/2010/06/add-your-own-image-blog-background-in.html
http://blogging.nitecruzr.net/2008/10/creating-horizontal-index-for-your-blog.html
http://www.wufoo.com/2011/02/03/eventregistration-form/
http://www.phpform.org/
http://www.myoutsourcedbrain.com/2009/11/blogger-archive-pages-with-only-post.html
http://jquerytools.org/forum/tools/35
http://code.blogger.com/2012/01/customising-threaded-comments.html

http://www.inte…

Very Important Margin Padding Edit for Blogger

How to reduce margin of my right side sidebar of blogger by css This will reduce the gap between right border and right inner side, margin. #sidebar-right-1 { margin-right:-10px; } This will reduce the gap between left border and left inner side, margin.[ .column-right-inner] this code will reduce the gap between right side sidebar and blog post left side
#sidebar-left-1 { margin-right:-20px; } .column-right-inner { margin-left:-25px; } How to reduce margin of my left side sidebar of blogger by css
#sidebar-left-1 { margin-left:-10px; }
How to hide navbar of blogger by css
#navbar-iframe {    display: none !important; }
How to control sidebar widget of blogger|Border|Margin|Padding|Background .sidebar .widget { background:#ffffff;  border: 1px solid #999999;  margin: 0px 0px 0.5em 0px;  padding:0px 0px 0px 3px; border:2px solid #E6E6E6; }
How to make style of text of blogger | Hover | control font style h4:hover{ font-size:2em; background-color:red; }
All this posted and published in the blog

Follow by Email