Hello,
I am looking for some help in merging 4 columns together without losin
information in any colum:
i.e.
If I have C A R S in 4 different columns, I want the fifth colum
to say CARS.

I did some research online and came across this tip:
____________________________________
Sub Connects()
Dim intRow As Integer
Dim txt As String
intRow = 1
Do Until IsEmpty(Cells(intRow, 1))
Cells(intRow, 1) = Cells(intRow, 1) & " - " & Cells(intRow, 2)
Cells(intRow, 2).ClearContents
Range(Cells(intRow, 1), Cells(intRow, 2)).Merge
intRow = intRow + 1
Loop
Columns(1).AutoFit
End Sub

_____________________________________

I inserted this into a Macro, but I have no idea on how to call thi
procedure. Can anyone please help??? Thanks

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com