View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default truncate text to first word

As long as there's a space between the first name and the rest:

=LEFT(TRIM(A1),FIND(" ",TRIM(A1))-1)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Harry C" wrote in message
...
I have a column with first names, some of which are concatenated with middle
initials or middle names. Is there a way to truncate to just the first
names?