Good day i have a paragraph of many text in it, and i need to break them in rows with 1900 characters in each.
Currently i am doing manually using LEFT for 1st break and the MID for remaining, but need a faster way as below:
If anybody can help to create a function (add in) so i can run down on multiple rows.
There are instructions at the top of the page explaining how to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks Alig..
I m attaching sample file
row 3, 4 is split just 2 rows using Left for row 3 & Mid for row 4.
CAn we prepare some function so i can use the same in full column as a formula/function
@pmbhome
You said 1900 but in your left and mid functions You used 1896 and 1899 for line 1 and 2. What is the reason?
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
Administrative Note:
Welcome to the forum.
This is the SECOND time you have opened a duplicate thread on this subject.
STOP doing that.
Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.
Please see Forum Rule #5 about thread duplication.
I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...rts-lines.html
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks