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
|