Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-13-2005, 01:32 PM
jamal420 jamal420 is offline
Novice
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.
Jamal
Reply With Quote
  #2  
Old 06-13-2005, 02:19 PM
Matrix's Avatar
Matrix Matrix is offline Excel Question ---Concatenation! Windows 10 Excel Question ---Concatenation! Office 2010
Admin
 
Join Date: Jan 2005
Posts: 393
Matrix is on a distinguished road
Default

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
Reply

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 04:01 AM.


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