Extract from the beginning of a text string

C

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
 
P

Pete_UK

With your text in A1, use this:

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

Hope this helps.

Pete
 
Top