Left, Right, Mid, Find...

**Petitboeuf** · 02-27-2007, 07:52 AM

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!!

**PeterB** · 02-27-2007, 08:17 AM

If you really want to combine the two equations, then :

=RIGHT(LEFT(D3,7),5)

OR you could use :

=MID(D3,3,5)

And, for C3 :

=RIGHT(D3,25)

OR are you looking for something a little cleverer?

**starguy** · 02-27-2007, 08:44 AM

Originally Posted by Petitboeuf

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!!

Hi
following function will return what you want in C3
=MID(D3,FIND(" ",D3)+1,100)

for combining A3 and B3 try
=A3&B3
or
=A3&" "&B3 (with a space between two values)

hope this would help you.