Skip to Content

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 31, 2016 at 01:58 PM

    HI Kurt,

    Try:

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

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded