How can I convert John Smith to John S

Microsoft Microsoft office excel 2007 ac...
December 15, 2010 at 12:27:25
Specs: Macintosh
How can I convert John Smith to John S

See More: How can I convert John Smith to John S

Report •

#1
December 15, 2010 at 14:00:39
Assuming that what you are looking for is the First Name plus 1 character after the space, this will work:

=LEFT(A1,FIND(" ",A1)+1)

However, that will not work for John Q Smith.

You'll get John Q

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •

#2
December 15, 2010 at 16:40:14
Thanks DerbyDad03, this formula will make my life much easier.

Report •
Related Solutions


Ask Question