Splitting out Content in 1 cell (which is currently separated by "
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!
|