Breaking News: Grepper is joining You.com. Read the official announcement!

get the first initials of a string in excel

Expensive Eel answered on November 9, 2021 Popularity 2/10 Helpfulness 1/10

answer get the first initials of a string in excel

get the first initials of a string in excel

Comment

Function FirstCharacters(pWorkRng As Range) As String
'Updateby20140514
Dim arr As Variant
Dim xValue As String
Dim OutValue As String
xValue = pWorkRng.Value
arr = VBA.Split(Trim(xValue))
For i = 0 To UBound(arr)
    OutValue = OutValue & VBA.Left(arr(i), 1) & "."
Next
FirstCharacters = OutValue
End Function

Popularity 2/10 Helpfulness 1/10 Language whatever

Source: www.extendoffice.com

Tags: excel get string whatever

Link to this answer
Share Copy Link