Suresh Behera

The Microsoft .Net Junkies

News

Blogroll

Reading

Merge or split cells or cell contents IN EXCEL 2003

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

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

 

Merge or split cells or cell contents

OK very good i followed the steps and try to merge two cell....wait a minute where is "Merge and Center" button and where is "formatting" menu on tool bar.Somehow i guess it is pointing to "Format" menu on Tool but somehow i could not found it...

Did i missed something..Don't know ..Yes,your right eve i try the note section also but no hope..

image

 

Then i thought it is for excel 2007 i went and check the help targeted version of excel ...no it is for excel 2003

 

image

 

I have no clue which excel 2003  file is pointing this help article but definitely it sounds like something is missing here.I use excel 2003 but did not found useful to me.

Here is what i found to merge two cells

Select two cell >>right click on it ..? click on format cells

image

 

then click on alignment tab ..? "Merge Cell" and then click  ok

 

image

 

I am using excel professional 2003 edition

image

 

if somebody has any idea please feel free to post comment here.

 

Thanks,

 

Suresh Behera

Posted: Jan 17 2008, 02:38 PM by Suresh Behera | with 13 comment(s) |
Filed under: ,

Comments

Kalpesh said:

Suresh,

What is it that you are looking for?

Are you facing a problem with merging or is this a solution?

Please pardon my ignorance.

# January 18, 2008 12:47 AM

rajbk said:

The "Merge and Center" button is available on the formatting tool bar. If the formatting tool bar is missing, click on View - ToolBars - Formatting. If you don't see the button on the formatting toolbar, click on the down arrow key to the right of the toolbar.

# January 18, 2008 10:43 AM

Matt said:

The best way is to write a formula.

If Suresh is in cell A1 and Behera in B1, i would write a formula as follows in C1

=A1&" "&B1

Hope this helps

Regards

Matt

# April 9, 2008 4:41 AM

Matt said:

You can get around this with a formula.

# April 9, 2008 8:21 AM

Aniruddha said:

I have merged 4 cells. and want to unmerge them into evenly distributed 3 cells. is it possible?

# May 27, 2008 2:49 AM

rahul jain said:

site is too helpful....

thanks

# June 12, 2008 12:31 PM

Dan J. said:

Thanks for this info. Saved a lot of cussing, and eye strain searching for the cion.

# July 24, 2008 10:59 AM

marlene basdeo said:

ohhhhhh......im so Lacking in intelligence.

# July 29, 2008 11:46 PM

Nirmal said:

I would like to split characters in a cell to two cells. I cant use text to columns, I dont have a common character in between the characters.

say I have FF16 in one column. I would like to split FF in one column and 16 in the other. I need to do this for different characters.

Anyone know how??

# August 22, 2008 7:04 AM

srik said:

"I have merged 4 cells. and want to unmerge them into evenly distributed 3 cells. is it possible? "

No way. You should split the cells and manually drag to adjust the widths.

# September 23, 2008 2:57 PM

Bobbie said:

I want to merge two columns of cells.  What is the formula I use.

# October 14, 2008 12:27 PM

Quang said:

Matt's suggestion of using '=A1&" "&B1' fomular works well for me. Thank you.

# December 6, 2008 6:51 PM

PRASAD said:

I have merged 3 cells BUT IT TAKES SPACE

# January 9, 2009 6:32 AM
Leave a Comment

(required) 

(required) 

(optional)

(required)