adding letter part 2

A

Andre

hi again

Can I add letters from different cells? Is there a formula
for it?
example

D C C D J O O D
B
on another sheet (take this letter example above)
have say under A1=D B1=C so on for the rest of the letters
A2=3 B2=2

Thanks for your help. Merci
 
R

Rollin_Again

Use the concatenate function. Type the following formula in any cell t
combine the contents of multiple cells.

=CONCATENATE(A1,B1,C1,D1)




Rolli
 
Top