![]() |
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 |
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? |
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? |
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