o.k., thanks to a very helpful person scotto, i have been able to
combine adjacent columns using the formula =A1&" "&B1 to populate
column C, however i initially didnt finish my question...

I need to combine the columns...each column is of equal length
containing both letters and numerals..I've tried but to no avail..in
simple words a formula probably
will look something like this??

Arow#&" "&Brow#???

Thanks,
rooniwife


--
rooniwife
------------------------------------------------------------------------
rooniwife's Profile: http://www.excelforum.com/member.php...o&userid=24904
View this thread: http://www.excelforum.com/showthread...hreadid=384673