I have downloaded some mail data on to a spread sheet and I would like to
combine row E vertical with F vertical imputing a dash between is that
possable to do all at once.... ie.. 33635 is in cell E and 0625 is in cell F.
I want to make it show 33635-0625. How do I do that all at once for the whole
sheet

=E2&"-"&TEXT(F2,"0000")

if you can have leading zeros in E2 do the same
for E2 like I did with F2 that is put it in the text function and put the
number of zeros for the number of digits you want to display

Copy down if there are more than one entry

--


Regards,


Peo Sjoblom

"Shauna" wrote in message
...
I have downloaded some mail data on to a spread sheet and I would like to
combine row E vertical with F vertical imputing a dash between is that
possable to do all at once.... ie.. 33635 is in cell E and 0625 is in cell
F.
I want to make it show 33635-0625. How do I do that all at once for the
whole
sheet