Splitting one cell into multiple cells

M

Money Penni

I want to split one cell into 3 rows and I cannot figure it out! Any help
would be appreciated....

Penni
 
G

Gary''s Student

Say we have 30 character in cell A1 and we want 10 in B1, 10 in C1 and 10 in D1

in B1:
=LEFT(A1,10)
in C1
=MID(A1,11,10)
In D1:
=RIGHT(A1,10)
 
S

Sean Timmons

that depends on how you'd like to split it...

If you just want it to show three sets of lines, you can enter the
information and use ALT+Enter to add a new line within the same cell.

If you want to break it based on, say, a space, you can do..

=LEFT(A2,find(" ",A2))
=mid(A2,find(" ",A2),find(" ",A2,find(" ",A2)+1))
=right(A2, len(a2)-find(" ",A2,find(" ",A2)+1))

or, if just a set number of characters,

=LEFT(A2,3)
=mid(a2,4,3)
=right(A2,len(a2)-6)
 
Top