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?
|