New Column with Last Name First Initial

[mvgust]

I've got a column lastname,firstname (no space after comma) and I need to add a new column based on the full name column but I need lastname,firstletter where first letter is the first letter in the firstname.

[az38 · Accepted solution]

hi @mvgust 

try this

Column = LEFT([Column1], SEARCH(",",[Column1])) & MID([Column1],SEARCH(",",[Column1])+1, 1)

[mvgust]

Awesome, thank you!