• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 148
  • 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
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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