if the original string is in A1
the formula you show in A2
in A3 as an example

=Right(A1,len(A1)-(len(A2)+1))

or if you want to us find to find it again

=Right(A1,len(A1)-Find(" ",A1))

or you can use the mid function

=MID(A1,FIND(" ",A1)+1,LEN(A1))


--
Regards,
Tom Ogilvy



"AMK4" <[email protected]> wrote in message
news:[email protected]...
>
> 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.
>
>
> --
> AMK4
> ------------------------------------------------------------------------
> AMK4's Profile:
http://www.excelforum.com/member.php...o&userid=19143
> View this thread: http://www.excelforum.com/showthread...hreadid=511600
>