HOW I MARGE THE COLUMNS FOR EXAMPLE 1 2 3 4 5 PUT IN ONE COLUMNS .

[Guest]

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

 

[Pete_UK]

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

 

[Roger Govier]

Hi
Try entering the following in F1
=A1&" "B1&" "&C1&" "&D1&" "&E1
and copy down as far as required.
If you want to then "fix" this data, copy all of the data in column F,
place cursor in F1 and Paste Special>Values