Hi
try
left(your_str,InStr(your_str," ")-1)

--
Regards
Frank Kabel
Frankfurt, Germany
"JayCeeJay" schrieb im
Newsbeitrag ...
I am trying to manipulate incoming field info that is rather
long-winded. What I wish to do is to diplay in the destination cells
only the data to the Left of the first space (or break in the string).
I realize it probably involves a combination of VBA functions, but I
would be grateful to anyone who could help me with it.