Thread: To join 1st line & 2nd line of text in text in Excel VBA Code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
norhaya[_2_] norhaya[_2_] is offline
external usenet poster
  
Posts: 1
Default To join 1st line & 2nd line of text in text in Excel VBA Code
Hi

I have a large text file for import. I need some ideas to combine to line of
strings (text)

Below is the sample of text

Before
sample (1)
aaaaaaa
bbbbbbbbbbbbbbbb


sample (2)
ccccccccccccc
dddddddd


After
Sample (1)
aaaaaaa bbbbbbbbbbbbbbbb

Sample (2)
ccccccccccccc dddddddd

I just need the vba code to join the text. Any inputs is highly appreciated.

Reply With QuoteReply With Quote