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

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Split cells next to 1 cell 1
Split single cell into multiple cells 2
Multiple numbers in a cell separated by a comma, need separate cel 0
Splitting cell contents into 2 cells 1
Split Cell Range into Multiple Cells 2
machine code for an alt-enter? 3
data splitting 1

Top