Splitting one cell into multiple cells

  • Thread starter Thread starter Money Penni
  • Start date Start date
M

Money Penni

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)
 
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)
 

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

Spliting a cell 3
How to split number and text string to separate cells? 5
Splitting out Content in 1 cell (which is currently separated by"ALT-ENTER") into multiple cells 1
Word Removing unwanted "lines" within a MS Word 10 table 1
Is it possible to split 1 cell into 3 cells w/o affecting other ce 1
Is there any way to split contents of a cell into more cells. 2
Mobile phone texts split into incoming and outgoing messages 0
splitting a cell 7

Back
Top