take everything from left on cell before space

[ag72]

desiHello, 

I have lot of cells which contains data like below and i want to take only the data mentioned on the left before spaces, so what formula i can use?

Current	Looking for
ABCS (ssss)	ABCS
AB (jjjjjjjjjj)	AB
ABSGDV (dddddddd)	ABSGDV

[JosephSerpis · Accepted solution]

Hi @ag72 you can achieve your desired results by using regex. The regex I used in the example I mocked up will find everything up to a space followed by more text.

[DOLEARY1]

Hi @ag72,

you could try a simple Regex string (.+)(?:\s):

[Austin004lasrado]

Hello  @JosephSerpis 

I have different issue here. I want to take the data everything before last space.

Like

'DAXM5 Index' then i need a output as 'DAXM5'

'G F5 Comdty' then i need a output as 'G F5'

Will there be any formula to support this?