View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default HOW I MARGE THE COLUMNS FOR EXAMPLE 1 2 3 4 5 PUT IN ONE COLUMNS .

If they are all numbers and you want to *ADD* them together, then use
this in F1:

=SUM(A1:E1)

This will give you a result of 15. If you want to *JOIN* them together
to give you 12345 as a result, then use this:

=A1&B1&C1&D1&E1

Hope this helps.

Please do not SHOUT in future postings.

Pete

danish wrote:
RESPECTED SIR,

SOLVE MY PROBLEM HOW I MARGE THE COLUMNS FOR EXAMPLE 1 2 3 4 5 COLUMNS ALL
DATA PUT IN ONE COLUMNS PLZ TELL ME THE SOLUTION PLEASE SIR MY LOTS OF WORK
ARE PENDING