Splitting out Content in 1 cell (which is currently separated by"ALT-ENTER") into multiple cells

S

Sunil Ahuja

Hello,

I have a lot of columns and a lot of rows in 1 spreadsheet. In one of
the columns, there are a lot of cells within that column which contain
multiple pieces of data separated by "ALT-ENTER" within each cell.
Does anyone know how to split out the content within these cell into
multiple rows/cells (again, the content is currently separated by "ALT-
ENTER")?

Thanks!
 
K

Kassie

Search for CHAR(10)

Say you have the problem in F10, and you want the left portion in G10, the
mid portion in H10, and the right portion in I10, then

In G10 =LEFT(F10,SEARCH(CHAR(10),F10,1)-1) will get you the portion before
the <Alt><Enter>

In H10 =MID(F10,LEN(G10)+1,SEARCH(CHAR(10),F10,LEN(G10)+2)-LEN(G10))

In I10 =RIGHT(F10,LEN(F10)-LEN(G10)+1-LEN(H10))
and so on
 

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

Splitting cell contents into 2 cells 1
Is it possible to split 1 cell into 3 cells w/o affecting other ce 1
Return multiple vales from a different spreadsheet into one cell 10
Not all cell contents copied 5
EXCEL: Separating data from 1 cell into multiple cells 5
Split Cell Range into Multiple Cells 1
Automatic line break in cells 4
Splitting cells in Excel 2007 1

Top