how to copy every thing written inside one Column without copying the empty cells?

[john65442]

Hi:-
i have a Column inside excel file
this Column contain written items in each cell [ for example Columns 1 to 150 are full ]
but at the end there are empty cells [ for example from Column 151 to the end ]

i want to copy Columns that are not empty and put them in text file
without copying the empty cells [which are from 151 to the end of the file]
how can i do this?

i want to merge Columns A & B
how can I merge two Columns ?
Thank you .

 

[Glory]

First part:

I don't know.

Second part, something like:

public sub test()
 
a = Range("A1:B" & Range("B" & Rows.Count).End(xlUp).Row)
 
For b = 1 to a
 
   Cells(b,3) = Cells(b,1) & Cells(b,2)
 
Next
 
End Sub

?

 

[Glory]

Take a look here. These people are takling about printing to a text file.

http://www.mrexcel.com/forum/showthread.php?t=542257

 

[john65442]

I found this software

Excel Extract Data & Text Software

and i am using and it solved the issue

it is from

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"جدول عادي"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]-->

http://www.sobolsoft.com​

Thank you