Only Capitalize First Letter & Delete Last Name

		Microsoft Office Forums > Microsoft Excel > Excel
Only Capitalize First Letter & Delete Last Name

12-10-2012, 07:02 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Only Capitalize First Letter & Delete Last Name

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Hi,

Try:

Code:

=PROPER(LEFT(TRIM(A1),SEARCH(" ",TRIM(A1)&" ")-1))

This formula will also handle any leading or end spaces.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Exceptions for 'Capitalize first letter of sentences'	gazpacho	Word	1	01-12-2012 11:43 AM
Is there a way to capitalize the all the words except the prepositions?	Jamal NUMAN	Word	2	08-06-2011 11:46 PM
is it possibe to capitalize every letter after a "colon space"	angeltread	Word VBA	4	01-17-2011 03:50 PM
delete email message via blackberry and have it delete on my pop3 and my outlook	Iamthestorm	Outlook	2	10-28-2010 12:21 AM
capitalize first letter of sentences	norco1	Word	0	06-25-2006 12:37 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:36 PM.