ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to merge two cells? (https://www.excelbanter.com/excel-discussion-misc-queries/213256-how-merge-two-cells.html)

Tippo22

How to merge two cells?
 
Hi,

I can't seem to finde any formula that makes it possible for me to merge two
cells.

My problem is that i have two cells with a persons name and with his
surname, how do i merge these two cells into one cell with the whole name in
it?

Martin

Max

How to merge two cells?
 
Eg, in C1: =A1&" "&B1
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"Tippo22" wrote:
I can't seem to finde any formula that makes it possible for me to merge two
cells.

My problem is that i have two cells with a persons name and with his
surname, how do i merge these two cells into one cell with the whole name in
it?



Tippo22

How to merge two cells?
 
Thanks a lot! :)

"Max" skrev:

Eg, in C1: =A1&" "&B1
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"Tippo22" wrote:
I can't seem to finde any formula that makes it possible for me to merge two
cells.

My problem is that i have two cells with a persons name and with his
surname, how do i merge these two cells into one cell with the whole name in
it?



Max

How to merge two cells?
 
Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"Tippo22" wrote in message
...
Thanks a lot! :)





All times are GMT +1. The time now is 11:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com