• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 93
  • Last Modified:

Merge two cells into one cell in Excel 2013

I am trying to merge two cells into one cell. But I always get the error message. Please see the picture. Anyone has some suggestion? Thank you
Capture.PNG
0
eemoon
Asked:
eemoon
  • 3
  • 2
3 Solutions
 
Roy CoxGroup Finance ManagerCommented:
It's best to avoid merging cells, use Center across selection from the Format Cells dialog. Choose Alignment then from the Horizontal drop down find this choice
1
 
eemoonAuthor Commented:
Thank you for your fast reply. can you tell in detail?
I think the excel table might has some special format because it refuses basic edit as it show message "Too many different cell formats"
Please see the picture
1.PNG
0
 
Michael GrahamData AnalystCommented:
My favorite way to do this is to concatenate the fields.

So if you have a table like

Name|City

Mike (Cell A2)|Boston (Cell B2)

You can merge them with the formula =A2&B2 in another cell (the output would be MikeBoston).  If you want a space between the two cells: =A2&" "&B2 (The output would be Mike Boston)

If you want a character between the two fields: =A2&"Character"&B2

Hope this helps a bit
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Roy CoxGroup Finance ManagerCommented:
Attach the file
0
 
eemoonAuthor Commented:
after reinstalling, it can work. Thank you
0
 
Roy CoxGroup Finance ManagerCommented:
Pleased to help
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now