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

Penni

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)
--
Gary''s Student - gsnu200832


"Money Penni" wrote:

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

Penni

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)

"Money Penni" wrote:

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

Penni