I am trying to put two Rows together
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 |
I am trying to put two Rows together
=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 |
All times are GMT +1. The time now is 04:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com