How to combine TRIM and LEFT to remove space and extract the first words

[ExcelNoobUser]

Hi, I wanted to ask if there's any way for me to use TRIM to remove the space in my cell and then left to get the first word in one cell, I tried to substitute to remove the space but they still output the second word after the space. Here is an example

42345566G Austin Texas

I want to only output 42345566G and get rid of all of the spaces before it, when I used substitute with lens it gave me 42345566G Austin with the spaces still intact, is there any formula that I could try to solve this, I even tried left trim but that only got rid of the spaces and outputted 42345566G Austin Texas, instead of just 42345566G that I thought it would output

 

[ExcelNoobUser]

Apparently the spaces were removed when I posted it, I'll use _ to make it easier to visualize

______42345566G Austin Texas

I want to only output 42345566G, when using substitute and lens I got ______42345566G Austin , and when using left trim I outputted 42345566G Austin Texas. Is there any way for me to only output 42345566G and remove the spaces before it using LEFT and TRIM functions

 

[MountainFog]

How about this?

=TEXTBEFORE(TRIM(F13)," ")

 

[ExcelNoobUser]

How about this?

=TEXTBEFORE(TRIM(F13)," ")

IT WORKED, THANK YOU, but is it possible for me to achieve the same end result using only a combination of the LEFT and TRIM functions ?

 

[MountainFog]

=LEFT(TRIM(F13),9)

 

[ExcelNoobUser]

=LEFT(TRIM(F13),9)

Thank You, It Worked and answered my question, but may I ask what the purpose of the 9 is for?

 

[MountainFog]

Trim removes all spaces on the left and right sides of the text.
Left takes a specified number of characters from the left side of a string. "42345566G" is 9 characters long, so you specify 9.

The textbefore takes all text before the first occurrence of the space, after trimming the spaces in front. This would be better if there were a variable number of characters in your string that needed to be extracted.