Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jada Mohammad   on Mar 14 In MS Office Category.

  
Question Answered By: Lois Schmidt   on Mar 14

Try this:

Function FirstName(pData As String)
iPos1 = InStr(pData, " ")
If iPos1 = 0 Then
FirstName = pData
Else
FirstName = Left(pData, iPos1 - 1)
End If
End Function

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Excel 2002 UDF Or get search suggestion and latest updates.


Tagged: