On Sun, 12 Feb 2006 22:12:43 -0600, AMK4
wrote:


I need to split a string into two parts: the first word, and whatever's
left of the remaining string. I do this to capture the first word:
Code:
--------------------
firstWord = Left(longString, Find(" ", longString) - 1)
--------------------
... however I don't know what's the easiest (smartest?) way to figure
out the remaining part of the string.

And another method:

With your formula above in B1:

=SUBSTITUTE(longString,B1&" ","")


--ron