Thread
: [Solved]
Excel Question ---Concatenation!
View Single Post
06-13-2005, 02:19 PM
Matrix
Windows 10
Office 2010
Admin
Join Date: Jan 2005
Posts: 429
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.
Matrix
View Public Profile
Find all posts by Matrix