Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Is there a way to convert names to initials?

I have a name field that I want to show up as just initials in the report.

So

John Smith

Baba Booey

Jane Doe

Would show up as:

JS

BB

JD

Is there a formula I can run to just show the names?

Thanks

Tags:
replied

If the string is separated by a coma, the formula would be:

(split({database field} , ',')[1])[1]&(split({database field} , ',')[2])[1]

-Abhilash

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question