need a formula that reads contents of cell up to a blank space

**nander** · 03-26-2014, 10:32 AM

A B
10255.01399 10X32X1 =LEFT(S20,11) RETURNS THE VALUE 10255.01399
10255R011036 10X36X1 =LEFT(S21,11) RETURNS THE VALUE 10255R01103 (I need 10255R011036)
10255.01199 11.25X13.25X1 What formula would read the characters from the left of the cell and stop at the space?
10255.01399 11X30X1
10255D01499 11X44X1
10255.01399 12X27X1

**AlKey** · 03-26-2014, 10:35 AM

Try this one

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

**nander** · 03-26-2014, 10:41 AM

ALKEY, yes that worked. I have some cells that only contain the the first value like 10255.01816
And when the formula is used it returns #VALUE!

What modification would correct this

**AlKey** · 03-26-2014, 10:45 AM

If you using Excel 2007 or higher

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

for older versions

=IF(ISERROR(LEFT(A1,FIND(" ",A1)-1)),A1,LEFT(A1,FIND(" ",A1)-1))