Pulling text from string until specified character

[hockey390]

Hi Everyone,

I did a lot of searching and everything I found was more complex than what I was looking for. Mostly VBA code, not just excel formula.

I would like to pull the left most characters in a string until the first "/".

String example: 10/1 Truck

Would like to just pull the "10"

Thanks for help in advance!

 

[VoG]

Try

=LEFT(A1,FIND("/",A1)-1)

 

[hockey390]

Perfect, thanks!

 

[hockey390]

Just as some additional learning for me... That is going to the left most location, moving right until it finds the "/", then pull the text starting -1, or one left of the "/" to the leftmost position, right? So if I wanted to include the "/" I would leave out the -1 or could change to +1, etc..

 

[VoG]

FIND("/",A1) returns the position of the / starting from the left. So to include the / delete the -1.