Extract from the beginning of a text string

  • Thread starter Thread starter Cassie
  • Start date Start date
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
 
Back
Top