AnsweredAssumed Answered

How to remove a middle initial

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

Title

How to remove a middle initial

Post

     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

      

     Tom

Outcomes