Prev: Getpivotdata and greater than or equal to
Next: Your entry cannot be used. An integer or decimal number may be req
From: da on 12 Mar 2010 16:55
Hi
is there any way to split the following cells using a formula, so the last
three numbers are separated from the number?
e.g.
Column A Column B
0C 264
0C 265
0C 267

0C264
0C265
0C267

Thank you
From: pmartglass on 12 Mar 2010 17:15
as long as it is consistant and you want to split the first two characters
into
assumes your concatinized item is in column A
column B and the last 3 characters into column C one way is

column B
=left(a1,2)

column C
=right(a1,3)

"da" wrote:

> Hi
> is there any way to split the following cells using a formula, so the last
> three numbers are separated from the number?
> e.g.
> Column A Column B
> 0C 264
> 0C 265
> 0C 267
>
> 0C264
> 0C265
> 0C267
>
> Thank you
From: da on 12 Mar 2010 17:26
Thank you. It worked.

"pmartglass" wrote:

> as long as it is consistant and you want to split the first two characters
> into
> assumes your concatinized item is in column A
> column B and the last 3 characters into column C one way is
>
> column B
> =left(a1,2)
>
> column C
> =right(a1,3)
>
> "da" wrote:
>
> > Hi
> > is there any way to split the following cells using a formula, so the last
> > three numbers are separated from the number?
> > e.g.
> > Column A Column B
> > 0C 264
> > 0C 265
> > 0C 267
> >
> > 0C264
> > 0C265
> > 0C267
> >
> > Thank you
 | 
Pages: 1
Prev: Getpivotdata and greater than or equal to
Next: Your entry cannot be used. An integer or decimal number may be req