Extract String Value before first space

[JustynaMZ]

I have a column with values and would like to receive column with results as below

Which formula to use?

Values	Expected result
1234AB jsijsposod oidjpsdps sdjo	1234AB
23AB dasw www	23AB

[Luke_C]

Hi @JustynaMZ 

The string functions can help:

Left([Values],FindString([Values],' '))

The Left() function expects Left(string,length). The FindString allows us to find the first location (expressed as a number) of the identified string, so we can pass that through as the length.

[MarqueeCrew]

@JustynaMZ ,

You stated your challenge so elegantly!  You need the leftmost characters prior to the first occurrence of a space.  Well here is the formula for your result:

Left([Values ],FindString([Values ], " "))

// Will take leftmost characters before first space

Cheers,

Mark