Forum Discussion

mvgust's avatar
mvgust
Helper III
6 years ago
Solved

New Column with Last Name First Initial

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 ...
Need Help
  • az38's avatar
    az38
    6 years ago

    hi mvgust 

    try this

    Column = LEFT([Column1], SEARCH(",",[Column1])) & MID([Column1],SEARCH(",",[Column1])+1, 1)
az38's avatar
az38
Community Champion
6 years ago

hi mvgust 

try this

Column = LEFT([Column1], SEARCH(",",[Column1])) & MID([Column1],SEARCH(",",[Column1])+1, 1)
  • mvgust's avatar
    mvgust
    Helper III
    6 years ago

    Awesome, thank you!