How to display full name and initial

I want to auto-fill full name and initial by joining 2 columns.
There are assumptions below:

Display full name in Column C by joining Column B and Column A

Column A Column B Column C

John Doe Doe, John

Display initial in Column F by joining Column D’s first letter and Column E’s first letter

Column D Column E Column F

John Doe DJ

Please advise what type (Computed?) and an option to use for the above setup.

  • If your first name and last name are in two different columns, you can create a full name column with a Template column.

  • You can then use a Computed → Experimental → Text → Initials column to extract the initials. You can use a separator such as a period or not.


Thank you for your resolutions.
Yes, I can resolve my issue.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.