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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW DO I EXTRACT NUMBERS FROM TEXT STRING 7
Extract first part of text string 1
find % number from text string 4
Extract number from text string based on number's format? 16
Extracting numbers from alphanumeric string 1
Extract Month From A Text String 4
Splitting cell contents into other columns 1
Extract text in middle using Mid and Find or Search 5

Top