Combining data from columns into one.

  • Thread starter Thread starter pos
  • Start date Start date
P

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.
 
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
 
Back
Top