Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Welcome
-- Max Singapore http://savefile.com/projects/236895 Downloads:21,000 Files:365 Subscribers:65 xdemechanik --- "Tippo22" wrote in message ... Thanks a lot! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I merge cells into one then delete the original cells? | Excel Worksheet Functions | |||
Merge of cells | Excel Worksheet Functions | |||
MERGE CELLS | New Users to Excel | |||
Merge Two Cells | Excel Discussion (Misc queries) | |||
How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) |