join together the data of different cells

Microsoft Book: office excel 2003 inside...
December 17, 2009 at 23:04:20
Specs: Windows XP
wrongly posted

See More: join together the data of different cells

Report •


#1
December 17, 2009 at 23:06:13
I have numbers as wel as text in col. J to W. I want these text
and numbers to be joined together and copied into a single
cell into corresponding row in col.B also when there is(are)
changes in col. J to W, that changes should be done
automatically in col.B. Is this possible?

For example:
 J        K       L      M     N     O    P    Q     R      

L/wall=   2       x      6     x     3    x    4    Nos.  (Suppose this line 
is in row2)

In Col.B2:
  L/wall= 2 x 6 x 3 x 4 Nos. (here J to R Col. data is 
seperated by a single space)


So when there is(are) changes in Col J2 to R2, the changes
should reflect in B2 as if it is copied and pasted link.


Report •

#2
December 18, 2009 at 03:10:40
Try either of these concatenation methods.

One uses the CONCATENATION function, the other uses the CONCATENATION Operator.

The etc. means to continue the pattern out as far as necessary.

=CONCATENATE(J2," ",K2," ",L2," ",M2," ",etc.)

or

=(J2&" "&K2&" "&L2&" "&M2&" "&etc.)


Report •

#3
December 18, 2009 at 21:15:41
Thanks DerbyDad03. Thats exactly what i need

Report •

Related Solutions


Ask Question