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" <Alastair79@discussions.microsoft.com> a écrit dans le message
de news: 1EB95589-B229-4C82-842A-64F707BAF590@microsoft.com...
>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.