Formula for stripping text
that seemed to work
"Vicky" wrote:
Sorry, there is no comma between the FIRST and MI. Should I change your
commas to a space?
Name appears like this
Smith, Mary A
Thanks!
"Luke M" wrote:
This checks to see if a middle initial is present, and leaves it out if true.
=IF(ISERROR(LEFT(A2,FIND(",",A2,FIND(",",A2)+1)-1)),A2,LEFT(A2,FIND(",",A2,FIND(",",A2)+1)-1))
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Vicky" wrote:
I have a list of names, listed as LAST, FIRST, MI. The Middle initial is
optional, and I would like to remove it for the purpose of creating a lookup
from another table.
I have been doing Text to Columns and then CONCATENATE for the first 2
columns.
I was wondering if there is a way to do this with a function. Thanks in
advance.
|