How to add Line Break in MS Excel (3 Methods including a Macro for Line Break))

[@ishwarsingh881]

Very nice presentation ❤

[@susenDeshmukh-zt7so]

Thanks for the this tricks It's very useful in my daily task. 👍

[@KalaripayattuKeraladelishddam]

Very informative

[@AjayAnandXLnCAD]

Thank you ☺️

[@mrIQ089]

finally. Tq Mater Ajay

[@roshanghadigaonkar8267]

Great video!!

[@AjayAnandXLnCAD]

Glad you enjoyed it

[@Daily.Fun.facts.channel]

Good it is what I am finding great job👍🏻

[@AjayAnandXLnCAD]

👍

[@Mu11en12]

Thank you very much!

[@AjayAnandXLnCAD]

My pleasure 😀

[@sachinkamble9359]

Nice video

[@WaliKhan-wq1sv]

thanks

[@andyt9132]

Thanks you saved me from getting fired

[@AjayAnandXLnCAD]

My pleasure :)

[@mehdizero93]

ty

[@manissery1956]

Thanks AJAY. Suppose we have used formulae textjoin, text etc and the result need to be split as required. Eg I need to get date on a separate line. Simple text of course we can do by using alt enter key, even lengthy formula can also be split into lines lie this, but how to break the resulting lines (formula result).

[@AjayAnandXLnCAD]

Haridas, thank you for that interesting question. You can use CHAR(10) for Line Break in formula results.

[@manissery1956]

@@AjayAnandXLnCAD thanks a lot

[@amariedarvai4970]

Thank you for this video, but let's say you are copying and pasting report info into Excel, and due to the formatting of the report, all of the info pastes only into A1, Line 1. I have been using Data Text to Columns, but I still have the problem of needing to know how to make a line break (at say, a date like May, June, etc, since in my reports, it is the Date where the line always needs to break). I would love to make a macro of this, because this is a repetitive issue I deal with. How would I do that?

[@AjayAnandXLnCAD]

I suggest to paste the data into notepad first, copy it from there and paste into Excel. You can also use Power Query for this task. With Power Query you can create a queries which will facilitate automation. I have done a few videos and wrote blog posts on this topic.

[@ramanarajan0507]

Can I get this macro ? Please

[@sachinkamble9359]

How to move data in next line added details in line break