Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Office

LinkBack Thread Tools Display Modes
Old 06-13-2005, 01:32 PM
Join Date: Jun 2005
Posts: 3
jamal420 is on a distinguished road
Default 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.

Reply With Quote
Old 06-13-2005, 02:19 PM
Matrix's Avatar
Matrix Matrix is offline Windows 7 32bit Office 2010 32bit
Join Date: Jan 2005
Posts: 396
Matrix is on a distinguished road

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.
Reply With Quote

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

All times are GMT -7. The time now is 12:30 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft