Printing data ranges from multiple columns to a single column

  • Thread starter Thread starter BushMonster
  • Start date Start date
B

BushMonster

I'm trying to create a column (d) in excel which will combine th
outputs from 3 other cells (a) (b) and (c).
I need column (d) to look up the unspecified range of information fro
column (a), followed immediatedly by the unspecified range o
information in column (b) again, followed by column (c). Column (d
now will contain the list abc:

a= 1 2 3
b= w x y z
c= * +

therefore:

d= 1 2 3 w x y z * +

I'm sure it's not that hard to do, I'm just very new to excel. Any hel
would be really appreciated. :
 
Hi

in column D use the formula
=A1 & " " & B1 & " " & C1

and copy down as required (easiest way to copy down is once you've typed
this formula in D1, move your mouse over the bottom right corner of D1 until
you see a +, then double click, this should fill the formula down as far as
there is information in column C)


Cheers
JulieD
 
BushMonster said:
I'm trying to create a column (d) in excel which will combine th
outputs from 3 other cells (a) (b) and (c).
I need column (d) to look up the unspecified range of information fro
column (a), followed immediatedly by the unspecified range o
information in column (b) again, followed by column (c). Column (d
now will contain the list abc:

a= 1 2 3
b= w x y z
c= * +

therefore:

d= 1 2 3 w x y z * +

I'm sure it's not that hard to do, I'm just very new to excel. Any hel
would be really appreciated. :)
Click to expand...

Try this ... in Cell D1, enter

=A1&""&B1&""&C
 
Back
Top