Bill Martin -- (Remove NOSPAM from address)
Guest
Re: Truncating a text string
gavin wrote:
>In A1 I have the following:
>
>
>A4 Black
>A4 Black+1
>A4 1 colour
>A4 2 colour
>A4 4 colour
>A3 Black
>A3 Black+1
>A3 1 colour
>A3 2 colour
>A3 4 colour
>
>
>I want to strip the leading two characters and the first space away leaving
>me with:
>
>
>
>Black
>Black+1
>1 colour
>2 colour
>4 colour
>Black
>Black+1
>1 colour
>2 colour
>4 colour
>
>
>I've been fiddling with this for a while but can't get it - I'd appreciate
>some help.
>
>
>Regards,
>
>
>
>
>Gavin
>
>
---------------------------------------------------------------
To strip off the three left characters try using:
[ ] = RIGHT(A1,LEN(A1)-3)
Bill
Bookmarks