Split the cells
 

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

Split the cells
 

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

Split the cells
 

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