Skip to main content

CONCATENATE | Excel Formulas

Concatenate meaning is to join or to combine together. It is  useful spreadsheet formula if you need to combine data into one cell. Say for example you had a first and last name, in cells W4796 and X4796 respectively. You would type =CONCATENATE(W4796 , " " , X4796), which would combine the names into one cell, with the " " adding a space in between.






Labels:

Comments

Post a Comment

If any doubts let me know..

Popular posts from this blog

concrete pole specification | how to calculate cement, sand and aggregate quantity in concrete

Today I will tell, how PCC pole concreting is done? Before knowing about our topic, let's take a little knowledge about PCC Polls.full form of pcc pole is Plain  Cement Concrete pole .There are various types of PCC Pole like 8 mtr 8.5 mtr ,9 mtr .but Now I will discuss about only 8.5 mtr pcc pole. As per Guaranteed Technical Perticulars(GTP) Total Length-8.5 mtr Pit depth-1.5 mtr Working load applied 300 mm from top-180 kg Weight of the pole-415 Kg. Top dimension-90mmx145 mm Bottom dimensions-90mm x 300 mm we have to maintain pit length is 1.5 mtr and pole should be inside pit is L/6 where L is length of the pole. Explained : L=8.5 mtr Pit depth=L/6+0.075(Base plate) Pit diameter =20 inch(0.508 mtr) Let's go to our topic now. How to calculate cement, sand and aggregate quantities for ratio 1:2:4 Pit Size For one cmt cement required -6 bag Our pit volume (dia-0.508 mtr where r-0.254, depth-1.5 mtr) Volume -pie*r2*h                =3.14*0.254*0...
Post a Comment
Read more

what are the possible causes of cable faults?

नमस्कार मित्रों,आज मैने HT AB CAble फॉल्ट कियुं होता है उसिके बारे में चर्चा करूंगा।    आप सभी जानते है कि एचटी एबीसी साइट इंजीनियर के लिए सरदर्दी बन जाती है। जैसे ही लाइन चार्ज करते है कुछ मिनटों या महीनों के बाद फॉल्ट आना पैदा करदेता है।   बहुत सारे इंजीनियर तो बोलना शुरू कर देते है कि खराब इनसुलेशन की बजहा से ऐसे फॉल्ट होता है।  बहुत सारे रिसर्च और अनुभव के बाद  बाद में यही नतीजे में पहुंचा कि जो इस्प्रकर की। 1) अन लोडिंग,स्टोरेज और हैंडलिंग सही से होना चाहिए। 2) टर्मिनेशन किट या ज्वाइंटिंग सही से होना चाहिए। 3) एआर्थिंग सही से होनी चाहिए जैसे कि टर्मिनल की latches  एआर्थिग  जरूर करना होता है। एक चीज ध्यान देना कि मैसेंजर तार को भी दोनों साइड में एर्थिंग करने की। ऐसे तो मैने ए भी कहूंगा कि  हर एक खंबे में मैसेंजर तार को एर्थिग करना चाहिए। Please Subscribe my YouTube channel ⁸ साइट पर केबल ड्रम की अन-लोडिंग, स्टोरेज और हैंडलिंग के लिए दिशानिर्देश जो इस प्रकार की होनी चाहिए।  केबल ड्रम की अनलोडिंग या तो क्रेन द्वारा या होइस्ट द्वारा या ट्रक ...
Post a Comment
Read more

Cable trench specification | Various type of cable trench

  Hello friends, I had told in my previous blogging that the current carrying capacity of different UG cables.Today I will tell you how the UG cable is laying and how the cable trench is done with the specification.   UG cable is very expensive, about 3-4 times expansive and also laying. But due to many reasons we have to do UG Cable. One of them is because of the reason   we have to do UG cable even after being so expensive, is density populated areas where Overhead Network cannot be used. However, the cable should be properly laid because it takes more time to find the fault than the overhead line.           Before selecting for laying UG cable, the current carrying capacity, voltage drop and short circuit current of the cable are very important factors which I had written earlier in blogging. Generally the life of the cable is 40-50 years. But Incorrect handling/laying can result in insulation damage and decreases...
Post a Comment
Read more