Combining data from columns into one.

[pos]

I would like to be able to combine the data from three different columns
into one column. I don't want a sum of the numbers though. Example:
in column A is the #123, column B is 456, column c is 789. I would
like to add one column that combines these numbers into 123456789. I
am not well versed in excel and would appreciate any advice and
suggestions.

 

[Gord Dibben]

pos

Assuming the 123,456,789 are in J4,K4,L4

=J4&K4&L4 will give you text 123456789

=(J4&K4&L4)*1 will give you the number 123456789

OR just enter the numbers =(123&456&789)*1

Gord Dibben Excel MVP