Splitting out Content in 1 cell (which is currently separated by"ALT-ENTER") into multiple cells
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! |
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! |
All times are GMT +1. The time now is 09:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com