Get First Initial of a Last Name

Split Text > Single Value Column COMBO

7 Likes

Very nice!

We just need some text manipulation functions in Glide.

1 Like

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.

@Makis_Theonas
Happy Glidiversary! :tada:

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

1 Like

Here’s an alternative version using Excel formula.

2 Likes

Only works on an Excel data source? Or any?

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)
2 Likes