Joe

If I understand

=A1&" "&B1&" "&C1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk

wrote in message
oups.com...
Here's an old post about merging 2 columns into one, how can I amend
this formula to make it 3 columns into one maintaining both sets of
data?


C1: =A1 & " " & B1


now say I want to merge columns A, B, and C?