combining two cells

's Computer Specifications

I have a list of names (one column of first names, and one
column of last names). I want to get the initials for the person.

For example:

A B
John Doe

A2=JD

's Computer Specifications

=LEFT(A1,1) & LEFT(B1,1)
--
Gary''s Student - gsnu200745

"Michelle" wrote:

> I have a list of names (one column of first names, and one
> column of last names). I want to get the initials for the person.
>
> For example:
>
> A B
> John Doe
>
> A2=JD

's Computer Specifications

=LEFT(A2)&LEFT(B2)

"Michelle" wrote:

> I have a list of names (one column of first names, and one
> column of last names). I want to get the initials for the person.
>
> For example:
>
> A B
> John Doe
>
> A2=JD

's Computer Specifications

Thank you very much. This was exactly what I was looking for.

"Teethless mama" wrote:

> =LEFT(A2)&LEFT(B2)
>
> "Michelle" wrote:
>
> > I have a list of names (one column of first names, and one
> > column of last names). I want to get the initials for the person.
> >
> > For example:
> >
> > A B
> > John Doe
> >
> > A2=JD

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combining cells	caseysmydog	Microsoft Excel Programming	3	6th Nov 2008 05:20 PM
Combining cells	=?Utf-8?B?QkFLRVJTTUFO?=	Microsoft Excel Misc	2	26th Jun 2007 07:33 PM
Combining the cells data for cells with same name	nik_gujarathi	Microsoft Excel Programming	6	1st Aug 2006 11:32 AM
Combining Cells	Greg B...	Microsoft Excel Programming	2	27th Feb 2005 03:25 PM
combining cells	bubba1965	Microsoft Excel Misc	8	5th Mar 2004 07:12 PM