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 firstname.

Need Help
  • az38's avatar
    az38
    6 years ago

    hi mvgust 

    try this

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

2 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    hi mvgust 

    try this

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