Extracting certain text from a cell

[Neil07979]

Hi All,

Hoping you can help me!

I have a text column in Excel - that I only want to extract a certain part of.

EG:
Cell A2: TNH6 Y (Result - TNH6)
Cell A3: TBJHK (Result - TBJHK)
Cell A4: TGHKGH (Result - TGHKGH)

Bassically - what I am trying to do is extract anything up to the first space within the cell and ignore anything after the space. The cell itself will never be more than 6 digits - but the space could come on the 4th or 5th.

Is there a function to do this - or could I create a function of my own - and how?

Thanks.

[StephenR]

Here's one way:

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

[EdMac]

Hi Neil,

=LEFT(A2,FIND(" ",A2))

Ed

[Neil07979]

Excellent - Thanks guys!

[daddylonglegs]

Simpler than using ISERROR.....

=LEFT(A2,FIND(" ",A2&" ")-1)