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.