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!

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

Kassie Kasselman
Change xxx to hotmail


"Sunil Ahuja" wrote:

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!