We have the data like this. मेरे पास ऐसा डाटा है We need output like below. we have to split year, month & day. हमें नीचे की तरह आउटपुट चाहिए। Use of text column feature, we have to extract year, month & day. Text to Column feature का उपयोग कर , हमें वर्ष, महीना और दिन निकालना है । […]
Read moreCopy All Sheet Data In Master_Sheet I have excel file which has 3 sheet,From below vba macro code we can copy all sheets data in master Sheet. मेरे पास तीन sheet वाली excel फाइल है.निचे लिखे VBA Macro Code से हम सारे sheets का डाटा Master Sheet में copy कर सकते हैं. Sub Add_All_sheet_Data() sheetcount = Sheets.Count Worksheets.Add after:=Sheets(Sheets.Count) ‘Worksheets.Add after:=Sheets(Sheetcount) ActiveSheet.Name = “Master” For i = 1 To sheetcount Sheets(i).Activate Range(“a1”).CurrentRegion.Select Selection.Copy Sheets(“Master”).Activate Range(“a1048576”).End(xlUp).Offset(1, 0).Select ActiveSheet.Paste If […]
Read moreEDATE With the use of Excel EDATE function, we add or subtract month, with a date. We use EDATE function to calculate Maturity Dates, Expiration Dates, Due Dates, Project Start Date, Project End Date. If we use month value as positive, then it will go future date, if we use month value as negative then it will go past date, if we use month value 0 then it will show same date. Here only month & year will be […]
Read moreLCASE We use LCASE function in excel macro. With use of lcase function we convert a string to lower case. We have COMPUTER value in A1 cell, I want that COMPUTER word will be converted in lower case like “computer” and will be pasted in A5 cell. For this we have to use Range(“A5”).Value=LCase(Range(“A1”).VALUE) LCASE Function का प्रयोग हमलोग Excel Macro में करते है. LCASE का प्रयोग कर हम किसी string के letter को Lower case में convert करते […]
Read moreRIGHT We can use RIGHT function in excel & macro both. With the help of right function we extract characters from right site of a cell value or string. हम Right Function का प्रयोग Excel & Macro दोनों में करते हैं. Right Function की मदद से हम किसी Cell की वैल्यू से Right side से characters निकाल सकते है. We have Computer value in Cell A1. We use Right(Range(“A1”).Value, 3) to pick 3 character from right side of A1 cell […]
Read moreWith Use of right function in MS Excel. We can extract some text from right side from a cell value. for Example:- If we have computer in A1 cell. With below formula we can extract 3 character from right side of call value Text Function
Read more