Get First Initial of a Last Name

[Robert_Petitto]

Split Text > Single Value Column COMBO

[Makis_Theonas]

Very nice!

We just need some text manipulation functions in Glide.

[nathanaelb]

Very nice @Robert_Petitto !

@Makis_Theonas
The column is experimental, but you can use Excel/GS formulae directly in Glide Tables: hyperformula column. I’ve experimented a bit, it’s worked for my simple tests.

[nathanaelb]

@Makis_Theonas
Happy Glidiversary!

[blairrorani]

I just used a similar approach to get “F. Last” (but only if you’re not a supplier).
Like so:

[ThinhDinh]

Here’s an alternative version using Excel formula.

[blairrorani]

Only works on an Excel data source? Or any?

[ThinhDinh]

That “Excel Formula” column should be available on any data sources. JavaScript can work as well, but I think Excel should be enough for this case.

IF(A2<>"Supplier",LEFT(A1,1)&". "&RIGHT(A1,LEN(A1)-FIND(" ",A1)),A1)