exce formula

How can I modify this formula =CONCATENATE(A1,B1) to allow for up to 5 leading zeros? Thanks

Hi all This question is related to VBA macro.. How to send automatic outlook mail every day (except sat and sun) at 10:30 am IST using VBA macro Example: To = abc@.com Sub = Reminder Body msg = hi xyz Trade review has been completed for today. what will be vba code for above Scenario ?

How can I in Excel, resolve this question about this table: Invoice Number | Item | Product | Value 1001 | 1 | potatoes | 100 1001 | 2 | tomatoes | 150 1002 | 1 | potatoes | 100 1003 | 1 | water | 50 1004...

Thanks for your support in advance:) I would like to know is there any possibility using IF function with MID to get result ? i am using formula is =IF(MID(A2,1,3)+0,IF(A2<=201,"TT,IF(A2<=202,"MT",IF(A2>3000,"ECT"))) Note! i have three types of ID's (starting id is from 201 & second starting...

Hi Guys, I have two vlookup formulas in two columns of a sheet which validates the value whether it is "Pass" or "fail" from another sheet of the same workbook. Here are the below 2 formulas :- 1) =IF(VLOOKUP(BY2&G2&BG2,Sheet2!A:I,9,0)>=BV2,"Pass","Fail") 2)...

I have a workbook with 7 sheets containing part number of a product in column and its cost in adjacent column. And the 7th sheet contains total number of parts in all the sheets. I want to change cost of some products but then I have to do the same in all sheets. Is there a way by which it...

here under is my excel sheet it gets every 5 minutes data. but i want to paste every 15 minutes data on G H I J K L column respectively. suppose at now time 9.00 AM when time 9.15 AM that data automatically paste on another mention column G H I J K L respectively . is it possible ...

Hello there, Need your help to resolve my query. I need a formula for given below criteria: I have two column, in 1st column i have some firm name and in 2nd there are status of the names like pending, received etc. Now the problem is, in 1st column firm names are in multiple rows with status...