PC Review


Reply
Thread Tools Rate Thread

combining two cells

 
 
=?Utf-8?B?TWljaGVsbGU=?=
Guest
Posts: n/a
 
      20th Sep 2007
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
 
Reply With Quote
 
 
 
 
=?Utf-8?B?R2FyeScncyBTdHVkZW50?=
Guest
Posts: n/a
 
      20th Sep 2007
=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

 
Reply With Quote
 
=?Utf-8?B?VGVldGhsZXNzIG1hbWE=?=
Guest
Posts: n/a
 
      20th Sep 2007
=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

 
Reply With Quote
 
=?Utf-8?B?TWljaGVsbGU=?=
Guest
Posts: n/a
 
      20th Sep 2007
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:41 PM.