AnsweredAssumed Answered

How to remove a middle initial

Question asked by illbe on Nov 29, 2012
Latest reply on Nov 29, 2012 by philmodjunk


How to remove a middle initial


     I have a field with the format: [lastName, firstName MI] all rolled into one (thanks to a weird system, not mine). I would like to know how to remove the middle initial from the string using a calculation. Any help would vbe greatlt appreciated before my poor head explodes :-)


     Thank You