FirstName in column A = Mike
FirstName in column B = Smith
Formula in column C =LEFT(A1,1)&B1 'Returns MSmith
Formula in column C =LEFT(A1,1)&" "&B1 'Returns M Smith
"Anthony" wrote:

I have two colums one with a first name and one with a last name I want to
CONCATENATE the first name and last name together, but I only want the first
initial of the first name and then the full last name to upload to a database
for users, is there any way in access for this to be accomplished. Thanks