Split the cells

  • Thread starter Thread starter da
  • Start date Start date
D

da

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
 
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)
 
Thank you. It worked.

pmartglass said:
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)
Click to expand...
 
Back
Top