Thread: [Solved] Only Capitalize First Letter & Delete Last Name
View Single Post
 
Old 12-10-2012, 07:02 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
Hi,

Try:
Code:
=PROPER(LEFT(TRIM(A1),SEARCH(" ",TRIM(A1)&" ")-1))
This formula will also handle any leading or end spaces.
Reply With Quote