Hi all

I am sure it will take you seconds and a scowl to answer my query as this is very basic...

In D3 I have the following data dumped form another software:

PR02687 BLAH CHSH FRY POTS 12x907

In B3 I then have =LEFT(D3,7) which gives me PR02687

In A3 I then have =RIGHT(B3,5) which gives me 02687. Any way of combining A3 and B3 by the way?

Now in C3 I would like to have "BLAH CHSH FRY POTS 12x907" without the code... what is the formula please?

Many thanks!!