VBA : Fix it Broken Spacing Text/Paragrahp After Copy Pasting From A Web Document

Susanto3311
3StarLounger
Posts: 243
Joined: 17 Feb 2022, 05:16

VBA : Fix it Broken Spacing Text/Paragrahp After Copy Pasting From A Web Document

Post by Susanto3311 »

hi all..

how to easy solve /fix for broken spacing after copy pasting from web document.
i hope someone give me solution or may be can use macro to solve this problem
for your helping, greatly appreciated..
I,m using office 2021.

here attachment file for easy to understanding
.susant
You do not have the required permissions to view the files attached to this post.

User avatar
SpeakEasy
4StarLounger
Posts: 565
Joined: 27 Jun 2021, 10:46

Re: VBA : Fix it Broken Spacing Text/Paragrahp After Copy Pasting From A Web Document

Post by SpeakEasy »

What is it supposed to look like?

Susanto3311
3StarLounger
Posts: 243
Joined: 17 Feb 2022, 05:16

Re: VBA : Fix it Broken Spacing Text/Paragrahp After Copy Pasting From A Web Document

Post by Susanto3311 »

i want to normal (correct) spacing for between text.

User avatar
HansV
Administrator
Posts: 78633
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: VBA : Fix it Broken Spacing Text/Paragrahp After Copy Pasting From A Web Document

Post by HansV »

Is this correct (I don't speak Bahasa Indonesia)?

Sehubungan dengan berita acara Sekretaris Direktorat Jenderal Kekayaan Negara nomor ND-xx/KN.yy/2024 tanggal 29 April 2024, hal tersebut hanya dapat dilakukan oleh Manajer SDM pada Sekretariat DJKN, bagi pegawai yang mengikuti pelatihan/pelatihan yang dilaksanakan oleh pihak ketiga
Best wishes,
Hans

Susanto3311
3StarLounger
Posts: 243
Joined: 17 Feb 2022, 05:16

Re: VBA : Fix it Broken Spacing Text/Paragrahp After Copy Pasting From A Web Document

Post by Susanto3311 »

yes, hans, it's correct.

User avatar
HansV
Administrator
Posts: 78633
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: VBA : Fix it Broken Spacing Text/Paragrahp After Copy Pasting From A Web Document

Post by HansV »

I don't know how to do this using VBA.
I copied the text of the document, and pasted it into Google Translate, with "Detect Language".
It correctly detected the language as Indonesian, and translated it to English.
I then switched the languages, so that Google translated the English back into Indonesian.
I copied the result and pasted it into the reply.
Best wishes,
Hans

User avatar
Charles Kenyon
5StarLounger
Posts: 630
Joined: 10 Jan 2016, 15:56
Location: Madison, Wisconsin

Re: VBA : Fix it Broken Spacing Text/Paragrahp After Copy Pasting From A Web Document

Post by Charles Kenyon »

See also: Cleaning Up Pasted Text by Suzanne Barnhill, MVP
http://wordfaqs.ssbarnhill.com/CleanWebText.htm