Maybe a macro solution???

Option Explicit
Sub testme()
Dim myRng As Range
Dim myCell As Range

With ActiveSheet
Set myRng = .Range("a1", .Cells(.Rows.Count, "A").End(xlUp))
End With

For Each myCell In myRng.Cells
myRng.Offset(0, 2).Value = myCell.Value _
& " " & myCell.Offset(0, 1).Value
Next myCell
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Another solution might be to give the workbook to someone else, let them do
whatever it takes to merge those two columns and have them return it to you with
no formulas.

Or...
Say your data is in A1:B10 (two columns of 10 rows).

Copy A1:A10 and paste into C1:C10

Now for each cell in b1:B10, select that cell, copy the contents from the
formula bar (that's important).

Then select C1. Hit F2 to edit it.
Hit a spacebar (to separate the values???)
hit ctrl-v to paste in the copied text.

Then do C2, C3, ...



April wrote:

I need to be able to merge two colums of text into one column without lossing
the information and I'm not allowed to use a formula! This is an assignment
and we are allowed to use any resource to find our answer. I hope someone
can give me a hand. Thanks

April

--

Dave Peterson