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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM question 4
Highlighting Cells being used in Calculation 3
Split individual cells? 2
how do i split a cell into 2 under a heading 2
Delimated Text 8
What is this? 4
Split Cells 2
Splitting data in cells 2

Back
Top