5 cells to 1

[dallas]

Hi.

I want to make a macro..

I want different number (0-9) from five different cells to be on
number in another cell.

for example..if
C16=5
D16=0
E16=9
F16=7
G16=3


the result in cell C20=50973



Regards
Dalla

 

[Don Guillett]

=a1&b1&c1
or look in help for
CONCATENATE

 

[keepITcool]

Dallas,

15 minutes ago i posted a VBA function for this..
subj: "Concatenation"
op : "Tony"

Autohr: keepITcool
MessageNr: 560274
MessageId: (this should be a clickable reference)


(or just scroll up a bit in the message list..


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >