I am splitting employee names to use for filling forms.
Currently I have employee names in column A like this
Jones, Thomas J
Smith, Susan
Jackson, Michael E JR
Wilson, Dan SR
I use this formula to create the field that only contains the middle intial
=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",LEN($A2))),((COLUMNS($A2:C2)-1)*LEN($A2))+1,LEN($A2)))&"."
However when Susans field populates I get a period even though she doesn't have a middle inital.
So her form looks like
Susan . Smith
Is there an adjustment I can make so when there is no middle initial I don't get a period?
Currently I have employee names in column A like this
Jones, Thomas J
Smith, Susan
Jackson, Michael E JR
Wilson, Dan SR
I use this formula to create the field that only contains the middle intial
=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",LEN($A2))),((COLUMNS($A2:C2)-1)*LEN($A2))+1,LEN($A2)))&"."
However when Susans field populates I get a period even though she doesn't have a middle inital.
So her form looks like
Susan . Smith
Is there an adjustment I can make so when there is no middle initial I don't get a period?