adding letter part 2

[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

 

[Ragdyer]

In A3 enter:
=COUNTIF($B$2:$Z$2,A1)
And drag across the columns to copy as needed.

 

[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