Splitting data from one cell into three cells 1

[ijes]

I wish to split the contents of one cell into 3 cells as follows;
Cell A1 contains (15 digits)
I wish to put the first 7 digits into B1 =left(a1,7) last 3 digits in D1 =right(A1,3) how do I put digits 8 to 12 (5 digits) into cell C1?
I know I could put the contents of A1 less the last three digits into another cell and return Right 5. Is there another way referencing only cell A1?

Ian

 

[xlhelp]

Hi, Ian!

There is also the MID function that lets you extract a string in the middle of another string.

in your case it would be

=MID(A1,8,5)

Hope that helps.

Indu

 

[Scott02]

Hi Ijes,

I see you've already got your answer, but you can also use a combination of left and right statements that works.

=left(right(a1,8),5)

Just another way, as I was unfamiliar with the =mid function, I had to improvise.

Scott

 

[scat]

or you could use text to columns (data menu), selecting fixed width option