=a1&b1
or
=a1&" "&b1
or
=a1&" "&text(b1,"00000")
or
=a1&" Has a balance due of: " & text(b1,"$#,##0.00")

A1 holds the text and B1 holds the number

fantasma wrote:

I was able to separate a column into 3 components ... (3 columns) ... and now
I want to re-combine two of them. I've tried to follow instructions for this
in the HELP area but cannot merge the two columns. (One contains 4
alpabetical letters, the other 4 or 5 numbers.)

How can I do this?? I'm using the latest version of Excel w/ XP.

--

Dave Peterson