Paragraph - Split from 1 Cell

0 views
Skip to first unread message

Ashu K

unread,
Dec 18, 2015, 12:58:30 AM12/18/15
to Excel VBA Lab
Dear Seniors,

We have 3 paragraphs in 1 Cell (A1), how can we split those 3 paragraphs in different cells.

Like, First Paragraph Extract from Cell A1 and paste in B1, Second Paragraph in C1 and third Paragraph in D1.

Is it possible.

Query sheet is attached.



Thanks & Regrds
Asu Kenith
Paragraph Split Query.xlsx

Ashish Kumar

unread,
Dec 18, 2015, 1:36:22 AM12/18/15
to Excel...@googlegroups.com
Dear Ashu,

Check this..!


Note : Please visit on group page for download the sheet.

Regards
Ashish Kumar
Paragraph Split - Resolved.xlsm

Ashu K

unread,
Dec 20, 2015, 1:16:24 AM12/20/15
to Excel VBA Lab
Dear Ashish Sir,

Sheet is Perfectly working. Thanks a lot.



Regards
Ashu Kenith

Ashish Kumar

unread,
Dec 20, 2015, 8:16:32 AM12/20/15
to Excel VBA Lab
Dear Ashu,

Welcome...!!



Regards
Ashish Kumar

Vibhuti Shrotriya

unread,
Dec 20, 2015, 8:28:35 AM12/20/15
to Excel VBA Lab
Dear Ashish,

It's working good according to requirement. Superb.

Thanks for sharing.




Thanks
Vibhuti

Ashish Kumar

unread,
Dec 20, 2015, 11:01:35 PM12/20/15
to Excel VBA Lab
Dear Vibhuti,

Thanks for acknowledge.


Regards
Ashish Kumar
Reply all
Reply to author
Forward
0 new messages