Extract from the beginning of a text string

[Cassie]

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 it’s 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

 

[Pete_UK]

With your text in A1, use this:

=LEFT(A1,SEARCH(" ",A1)-1)

Hope this helps.

Pete

 

[Jacob Skaria]

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

If this post helps click Yes

 

[Mike H]

Glad I could help

Mike

Mike

many thanks - that works a treat
Cassie