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