Truncating a text string

From: "gavin" <no-one@xxxxxxxx>
Date: Tue, 10 May 2005 20:01:58 +0100

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

.

Follow-Ups:
- Re: Truncating a text string
  - From: Bill Martin -- (Remove NOSPAM from address)
- RE: Truncating a text string
  - From: Peo Sjoblom

Prev by Date: RE: simple yet evading
Next by Date: changing the width of the font drop-down menu box?
Previous by thread: NEED HELP QUICK AGAIN!
Next by thread: RE: Truncating a text string
Index(es):
- Date
- Thread

Relevant Pages

RE: Truncating a text string
... Regards, ... Peo Sjoblom ... "gavin" wrote: ... Prev by Date: ...
(microsoft.public.excel.misc)
Re: Add numbers accross columns after stripping away text
... Gavin ... >> SUMPRODUCT might have to get involved but it all got a bit much for me! ... >> Regards, ... Prev by Date: ...
(microsoft.public.excel.misc)
Re: Vim two space indentation
... John Maclean wrote: ... Regards, ... Gavin ... Prev by Date: ...
(comp.lang.ruby)
Norman T300 Part Required
... me - though I thought it looked a bit fragile before I started fiddling with ... Thanks & Regards ... Dan ... Prev by Date: ...
(uk.rec.engines.stationary)
Re: Add numbers accross columns after stripping away text
... >I have the following data in a spreadsheet: ... Prev by Date: ...
(microsoft.public.excel.misc)