Try,

=TRIM(LEFT(A1,FIND(" ",A1)))

Mike

"Cassie" wrote:

I want to extract a series of characters from the beginning of a text string,
before the first space, for example
R070056-01a blah blah blah
But sometimes its the first 7 or 9 or 10 or 11 characters it varies
Can someone please let me know of a formula to extract the data to the first
space?
Many thanks
Cassie