#1
|
|||
|
|||
Excel Question ---Concatenation!
Hello all,
Thanks in advance for your help. I have a column for first name and another for last name. I would like to make a column with full name with concatenating first name and last name. The problem though in the full name column both names are connected together, I would like a space or two! Any suggestions. Thanks again. Jamal |
#2
|
||||
|
||||
Assume that cell A1 contains the data "John", cell B1 contains the data "Smith", to have a full name in another cell, use the following formula:
=(A1 & " " & B1) Then copy this cell to all other cells in full name column. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Opening multiple Excel files within the same Excel window. | lost9471 | Excel | 2 | 05-01-2010 01:57 PM |
!!!TEXT BOX QUESTION!!! | wrennels | Word | 2 | 02-27-2009 04:34 AM |
How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |
Need help with this question... | lllDNYlll | Outlook | 0 | 05-04-2006 07:17 AM |
Categories question & replying with attachment question | glitzymama | Outlook | 0 | 03-15-2006 09:32 AM |