CONCATENATE Question

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

Mike
Fri Mar 14 20:36:01 CDT 2008

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

Pete_UK
Fri Mar 14 20:55:45 CDT 2008

A slight variation on Mike's formula, to ensure consistency:

=3DUPPER(LEFT(A1,1))&" "&PROPER(B1)

will always ensure you get M Smith, even if you have mike and sMITH in
the other cells.

Hope this helps.

Pete

On Mar 15, 1:36=A0am, Mike <M...@discussions.microsoft.com> wrote:
> FirstName in column A =3D Mike
> FirstName in column B =3D Smith
> Formula in column C =3DLEFT(A1,1)&B1 'Returns MSmith
> Formula in column C =3DLEFT(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 f=
irst
> > initial of the first name and then the full last name to upload to a dat=
abase
> > for users, is there any way in access for this to be accomplished. =A0Th=
anks- Hide quoted text -
>
> - Show quoted text -

PeterPan20081225
Fri Mar 14 20:56:00 CDT 2008

Try this:

A B C
1 Juan Cruz =concatenate(left(A1,1)," ",B1)
2 Bill Clinton =concatenate(left(A2,1)," ",B2)




--
"I think, therefore I am". Descartes


"Mike" wrote:

> 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

Anthony
Sun Mar 16 18:31:02 CDT 2008

Thanks for everyones help.

"Pete_UK" wrote:

> A slight variation on Mike's formula, to ensure consistency:
>
> =UPPER(LEFT(A1,1))&" "&PROPER(B1)
>
> will always ensure you get M Smith, even if you have mike and sMITH in
> the other cells.
>
> Hope this helps.
>
> Pete
>
> On Mar 15, 1:36 am, Mike <M...@discussions.microsoft.com> wrote:
> > 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- Hide quoted text -
> >
> > - Show quoted text -
>
>