Extract Left Most Characters Until A SpaceOct 6, 2006
I am trying to write a function that finds and breaks a cell about the first space.
Dim Space As Integer
Set Space = .Find(" ", name)
Firstname = Left(name, Space)
firstname = left(name,find(" ",name)-1))