![]() |
|
#5
|
||||
|
||||
|
Hi,
Try: Code:
=PROPER(LEFT(TRIM(A1),SEARCH(" ",TRIM(A1)&" ")-1))
|
|
|
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 |