09-19-2006, 05:19 PM
|
 |
"Eagle Eyed" Forum Moderator
|
|
Join Date: 14 Feb 2005
Location: Worcester, UK
MS Office Version:Excel 2003 (Work) and 2007 (Home)
Posts: 6,095
|
|
Quote:
|
Originally Posted by VBA Noob
Hi,
Would this not work
=UPPER(LEFT(A8,2))&" "&RIGHT(TRIM(A8),LEN(TRIM(A8))
-IF(ISERROR(FIND(" ",TRIM(A8),FIND(" ",TRIM(A8),1)+1)),FIND(" ",TRIM(A8),1),FIND(" ",TRIM(A8),FIND(" ",TRIM(A8),1)+1)))
VBA Noob
|
Hello VBA Noob,
No I can't get it to work, it gives the first and second letter of the first name and the surname, try on
Hello VBA Noob and you get "HE Noob" 
oldchippy 
|