Greetings to everyone. Im having this little problem to make a macro that would alternately delete a hard return with colon delimiter or separator after each deletion. Below is the sample data and the expected output.
SAMPLE
Location
Sims Drive / Aljunied Road
Site Area
6,312.2 m2
Allowable Development
Business 1
Maximum Gross Plot Ratio
2.5
Maximum Building Height
64 m AMSL *
Lease Period
60 years
EXPECTED RESULT
Location: Sims Drive / Aljunied Road
Site Area: 6,312.2 m2
Allowable Development: Business 1
Maximum Gross Plot Ratio: 2.5
Maximum Building Height: 64 m AMSL *
Lease Period: 60 years
Thanks in advance
Bookmarks