{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Omit First Line - Examples","Omit 1st line with formula","Remove 1st line Excel 365","Remove 1st line with Regex","Delete first line with VBA"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Omit First Line - Examples","index":0,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,1,3,2],[5,1,5,2],[8,2,8,3],[11,1,11,2]]}
[]
[]
[]
[null,"Omit First Line in Excel Cell"]
[]
[null,"The workbook shows how to remove the first line in Excel cells by using native formulas, regular expressions, and VBA macro."]
[null,"Author","Ablebits.com"]
[null,"Last update","2023-08-28"]
[null,"Tutorial URL","How to omit the first line in Excel cell"]
[]
[null,"Examples:"]
["• ","Omit the first line in Excel cell with formula\n•\tRemove first line of text in Excel 365 [excel365]\n•\tOmit first line in cell using RegEx [regex]\n•\tDelete first line in cell with VBA [vba]"]
["• ","Remove first line of text in Excel 365"]
["• ","Omit first line in cell using RegEx"]
["• ","Delete first line in cell with VBA"]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[null,"The workbook contains the following macro:"]
[null,"DeleteFirstLine - deletes the first line of text from the selected cells."]
[]
[null,"How to use the macros:"]
[null,"1. Keep this workbook open."]
[null,"2. Open your own workbook in which you want to remove opening lines."]
[null,"3. In your workbook, select the range where you want to remove the first line of text."]
[null,"4. Press Alt + F8, select the DeleteFirstLine macro, and click Run."]

{"sheet":"Omit 1st line with formula","index":1,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Omit first line in Excel cell"]
["String","Result"]
["Line1",{"$f":"IFERROR(RIGHT(A3, LEN(A3) - FIND(CHAR(10), A3)), A3)","v":"Line1"}]
["Line1\nLine2",{"$f":"IFERROR(RIGHT(A4, LEN(A4) - FIND(CHAR(10), A4)), A4)","v":"Line2"}]
["Line1\nLine2\nLine3","Line2\nLine3"]
["Very very very long line of text 1\nVery very very long line of text 2\nVery very very long line of text 3\nVery very very long line of text 4","Very very very long line of text 2\nVery very very long line of text 3\nVery very very long line of text 4"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Remove 1st line Excel 365","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Remove the first line in a cell in Excel 365"]
["String","Result"]
["Line1",{"$f":"IFERROR(_xlfn.TEXTAFTER(A3, CHAR(10)), A3)","v":"Line1"}]
["Line1\nLine2",{"$f":"IFERROR(_xlfn.TEXTAFTER(A4, CHAR(10)), A4)","v":"Line2"}]
["Line1\nLine2\nLine3","Line2\nLine3"]
["Very very very long line of text 1\nVery very very long line of text 2\nVery very very long line of text 3\nVery very very long line of text 4","Very very very long line of text 2\nVery very very long line of text 3\nVery very very long line of text 4"]

{"sheet":"Remove 1st line with Regex","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Omit the first line in Excel cell using RegEx"]
["String","Result"]
["Line1",{"$f":"RegExpReplace(A3, \".*\\n\", \"\", 1)","v":"Line1"}]
["Line1\nLine2",{"$f":"RegExpReplace(A4, \".*\\n\", \"\", 1)","v":"Line2"}]
["Line1\nLine2\nLine3",{"$f":"RegExpReplace(A5, \".*\\n\", \"\", 1)","v":"Line2\nLine3"}]
["Very very very long line of text 1\nVery very very long line of text 2\nVery very very long line of text 3\nVery very very long line of text 4",{"$f":"RegExpReplace(A6, \".*\\n\", \"\", 1)","v":"Very very very long line of text 2\nVery very very long line of text 3\nVery very very long line of text 4"}]

{"sheet":"Delete first line with VBA","index":4,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Delete first line in a cell with VBA"]
["Source data"]
["Line1"]
["Line1\nLine2"]
["Line1\nLine2\nLine3"]
["Very very very long line of text 1\nVery very very long line of text 2\nVery very very long line of text 3\nVery very very long line of text 4"]
[]
[]
["How to use the macro to delete the first line of text in a cell:"]
[" "]
["1. Select the range A3:A6."]
["2. Press Alt + F8 to open the macro dialog box."]
["3. Choose the DeleteFirstLine macro."]
["4. Click Run to execute the code."]
[]
["Word of caution! The VBA code deletes the first line in the original cells. Since actions performed by Excel macros cannot be undone, it stands to reason to back up the worksheet before running the macro."]