Hello
No real need for a macro there but anyway:
Either
Left(Range("A1").Value, Len(Range("A1").Value) - 4)
Or
MID(Range("A1").Value),1,FIND("" "",Range("A1").Value,1)-1)

will return the text without the " PBL" part.

HTH
Cordially
Pascal


"Alastair79" a écrit dans le message
de news: ...
I need to be able via a macro to copy only a portion of a cells contents to
a
different part of the sheet. What I have is like below:-

"CLOBMIDDLETON PBL" or "CLOBDIDCOT PBL"

I need to get ride of the "PBL" part and as you can see the first part of
the cell varies in length. Is there any way to tell excel to copy till the
space?

Thanks............. Alastair.