|
|
#2
12-03-2012, 01:41 PM
|
||||
|
||||
Welcome to the forum.
1. =LEFT(A1,SEARCH(" ",A1)-1) 2. =PROPER(A2) 
|
|
|
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 |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode