Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 06-13-2005, 01:32 PM
jamal420 jamal420 is offline
Excel Question ---Concatenation!
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 Excel Question ---Concatenation! Windows 10 Excel Question ---Concatenation! Office 2010
Join Date: Jan 2005
Posts: 395
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
Excel Question ---Concatenation! Opening multiple Excel files within the same Excel window. lost9471 Excel 2 05-01-2010 01:57 PM
Excel Question ---Concatenation! !!!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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:38 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd. is not affiliated with Microsoft