Thread: [Solved] Only Capitalize First Letter & Delete Last Name
View Single Post
 
Old 12-04-2012, 08:47 AM
zulhfreelancer's Avatar
zulhfreelancer zulhfreelancer is offline Mac OS X Office for Mac 2011
Novice
  
Join Date: Dec 2012
Posts: 5
zulhfreelancer is on a distinguished road
Default
Quote:
Originally Posted by Colin Legg View Post
Welcome to the forum.

1. =LEFT(A1,SEARCH(" ",A1)-1)
2. =PROPER(A2)
Thank you very much!
Reply With Quote