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" wrote in message
...
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