<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://weblogs.asp.net/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Suresh Behera : Excel</title><link>http://weblogs.asp.net/sbehera/archive/tags/Excel/default.aspx</link><description>Tags: Excel</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP1 (Build: 20510.895)</generator><item><title>Merge or split cells or cell contents IN EXCEL 2003</title><link>http://weblogs.asp.net/sbehera/archive/2008/01/17/merge-or-split-cells-or-cell-contents-in-excel-2003.aspx</link><pubDate>Thu, 17 Jan 2008 19:38:35 GMT</pubDate><guid isPermaLink="false">c06e2b9d-981a-45b4-a55f-ab0d8bbfdc1c:5613724</guid><dc:creator>Suresh Behera</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://weblogs.asp.net/sbehera/rsscomments.aspx?PostID=5613724</wfw:commentRss><comments>http://weblogs.asp.net/sbehera/archive/2008/01/17/merge-or-split-cells-or-cell-contents-in-excel-2003.aspx#comments</comments><description>&lt;p&gt;I wanted to merge two cell in excel 2003.Question is how ? This sounds like very simple things for professional user and but it took me a hour to figure out the solution. ere is what i did &lt;/p&gt;  &lt;p&gt;1. I tryed few left click ,right click and search few buttons on excel tool bar and did not fond anything...Now it is time to search Microsoft Office site this is what i found&lt;/p&gt;  &lt;p&gt;&amp;#160;&lt;/p&gt;  &lt;p&gt;&lt;a href="http://office.microsoft.com/en-us/excel/HP052510211033.aspx" target="_blank"&gt;Merge or split cells or cell contents&lt;/a&gt;&lt;/p&gt;  &lt;p&gt;OK very good i followed the steps and try to merge two cell....wait a minute where is &amp;quot;Merge and Center&amp;quot; button and where is &amp;quot;formatting&amp;quot; menu on tool bar.Somehow i guess it is pointing to &amp;quot;Format&amp;quot; menu on Tool but somehow i could not found it...&lt;/p&gt;  &lt;p&gt;Did i missed something..Don't know ..Yes,your right eve i try the note section also but no hope..&lt;/p&gt;  &lt;p&gt;&lt;a href="http://weblogs.asp.net/blogs/sbehera/WindowsLiveWriter/MergeorsplitcellsorcellcontentsINEXCEL20_CDDA/image_4.png"&gt;&lt;img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="248" alt="image" src="http://weblogs.asp.net/blogs/sbehera/WindowsLiveWriter/MergeorsplitcellsorcellcontentsINEXCEL20_CDDA/image_thumb_1.png" width="607" border="0" /&gt;&lt;/a&gt;&lt;/p&gt;  &lt;p&gt;&amp;#160;&lt;/p&gt;  &lt;p&gt;Then i thought it is for excel 2007 i went and check the help targeted version of excel ...no it is for excel 2003&lt;/p&gt;  &lt;p&gt;&amp;#160;&lt;/p&gt;  &lt;p&gt;&lt;a href="http://weblogs.asp.net/blogs/sbehera/WindowsLiveWriter/MergeorsplitcellsorcellcontentsINEXCEL20_CDDA/image_6.png"&gt;&lt;img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="218" alt="image" src="http://weblogs.asp.net/blogs/sbehera/WindowsLiveWriter/MergeorsplitcellsorcellcontentsINEXCEL20_CDDA/image_thumb_2.png" width="605" border="0" /&gt;&lt;/a&gt; &lt;/p&gt;  &lt;p&gt;&amp;#160;&lt;/p&gt;  &lt;p&gt;I have no clue which excel 2003&amp;#160; file is pointing this &lt;a href="http://office.microsoft.com/en-us/excel/HP052510211033.aspx" target="_blank"&gt;help article&lt;/a&gt; but definitely it sounds like something is missing here.I use excel 2003 but did not found useful to me.&lt;/p&gt;  &lt;p&gt;Here is what i found to merge two cells&lt;/p&gt;  &lt;p&gt;Select two cell &amp;gt;&amp;gt;right click on it ..? click on format cells &lt;/p&gt;  &lt;p&gt;&lt;a href="http://weblogs.asp.net/blogs/sbehera/WindowsLiveWriter/MergeorsplitcellsorcellcontentsINEXCEL20_CDDA/image_8.png"&gt;&lt;img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="310" alt="image" src="http://weblogs.asp.net/blogs/sbehera/WindowsLiveWriter/MergeorsplitcellsorcellcontentsINEXCEL20_CDDA/image_thumb_3.png" width="306" border="0" /&gt;&lt;/a&gt; &lt;/p&gt;  &lt;p&gt;&amp;#160;&lt;/p&gt;  &lt;p&gt;then click on alignment tab ..? &amp;quot;Merge Cell&amp;quot; and then click&amp;#160; ok&lt;/p&gt;  &lt;p&gt;&amp;#160;&lt;/p&gt;  &lt;p&gt;&lt;a href="http://weblogs.asp.net/blogs/sbehera/WindowsLiveWriter/MergeorsplitcellsorcellcontentsINEXCEL20_CDDA/image_10.png"&gt;&lt;img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="300" alt="image" src="http://weblogs.asp.net/blogs/sbehera/WindowsLiveWriter/MergeorsplitcellsorcellcontentsINEXCEL20_CDDA/image_thumb_4.png" width="425" border="0" /&gt;&lt;/a&gt; &lt;/p&gt;  &lt;p&gt;&amp;#160;&lt;/p&gt;  &lt;p&gt;I am using excel professional 2003 edition &lt;/p&gt;  &lt;p&gt;&lt;a href="http://weblogs.asp.net/blogs/sbehera/WindowsLiveWriter/MergeorsplitcellsorcellcontentsINEXCEL20_CDDA/image_12.png"&gt;&lt;img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="123" alt="image" src="http://weblogs.asp.net/blogs/sbehera/WindowsLiveWriter/MergeorsplitcellsorcellcontentsINEXCEL20_CDDA/image_thumb_5.png" width="407" border="0" /&gt;&lt;/a&gt; &lt;/p&gt;  &lt;p&gt;&amp;#160;&lt;/p&gt;  &lt;p&gt;if somebody has any idea please feel free to post comment here.&lt;/p&gt;  &lt;p&gt;&amp;#160;&lt;/p&gt;  &lt;p&gt;Thanks,&lt;/p&gt;  &lt;p&gt;&amp;#160;&lt;/p&gt;  &lt;p&gt;&lt;a title="Suresh Behera" href="http://www.sureshbehera.com" target="_blank"&gt;Suresh Behera&lt;/a&gt;&lt;/p&gt;&lt;img src="http://weblogs.asp.net/aggbug.aspx?PostID=5613724" width="1" height="1"&gt;</description><category domain="http://weblogs.asp.net/sbehera/archive/tags/MS+Office/default.aspx">MS Office</category><category domain="http://weblogs.asp.net/sbehera/archive/tags/Excel/default.aspx">Excel</category></item></channel></rss>